| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Christian Schröder <cs(at)deriva(dot)de> |
| Cc: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Performance Issues |
| Date: | 2007-09-21 21:58:49 |
| Message-ID: | 20070921215849.GF13986@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Christian Schröder wrote:
> I think it is my job as db admin to make the database work the way my users
> need it, and not the user's job to find a solution that fits the database's
> needs ...
>
> Is there really nothing that I can do?
You can improve the selectivity estimator function. One idea is that if
you are storing something that's not really a general character string,
develop a specific datatype, with a more precise selectivity estimator.
If you are you up to coding in C, that is.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2007-09-21 22:12:57 | Re: Unable to start PostgresSQL Server |
| Previous Message | Daniel B. Thurman | 2007-09-21 21:28:45 | Unable to start PostgresSQL Server |