| From: | Miroslav Šulc <miroslav(dot)sulc(at)startnet(dot)cz> |
|---|---|
| To: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
| Cc: | PGSQL mailing list <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: General query optimization howto |
| Date: | 2005-03-13 13:57:53 |
| Message-ID: | 423446E1.1020804@startnet.cz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Peter Eisentraut wrote:
>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.
>
>
>
I've read that one. Sure it is good starting point but for a newbie (=
me) it's not enough :-(
Miroslav Šulc
| Attachment | Content-Type | Size |
|---|---|---|
| miroslav.sulc.vcf | text/x-vcard | 387 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Miroslav Šulc | 2005-03-13 14:03:14 | Re: General query optimization howto |
| Previous Message | Ragnar Hafstað | 2005-03-13 12:12:05 | Re: General query optimization howto |