| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | Miroslav Šulc <miroslav(dot)sulc(at)startnet(dot)cz> |
| Cc: | PGSQL mailing list <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: General query optimization howto |
| Date: | 2005-03-13 11:13:38 |
| Message-ID: | 200503131213.38718.peter_e@gmx.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Miroslav Šulc wrote:
> is there on the net any general howto on SQL query optimizations? We
> have recently moved our project from MySQL to PostgreSQL and are
> having problem with one of our queries.
I doubt that there is a generic documentation on SQL optimization,
because this heavily depends on the particular implementation that you
are using.
> The EXPLAIN command is surely
> useful but I don't know how to read it and how to use the output to
> optimize the query so I'm looking for some intro that could help me.
You should probably start with the Performance Tips chapter in the
PostgreSQL documentation.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ragnar Hafstað | 2005-03-13 12:12:05 | Re: General query optimization howto |
| Previous Message | Ron Mayer | 2005-03-13 06:11:44 | Re: [PATCHES] A way to let Vacuum warn if FSM settings are low. [final?] |