| From: | Erwin Moller <erwin(at)darwine(dot)nl> |
|---|---|
| To: | "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Tutorial EXPLAIN for idiots? |
| Date: | 2007-09-07 11:50:44 |
| Message-ID: | 46E13B14.3010902@darwine.nl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
A. Kretschmer wrote:
> am Fri, dem 07.09.2007, um 12:30:06 +0200 mailte Erwin Moller folgendes:
>
>> Hi group,
>>
>> Does anybody know of an tutorial for EXPLAIN for idiots like me?
>> (I am fairly confortable with Postgres, but never used EXPLAIN before.)
>>
>> I need to optimize a few slow running queries, but I am not really
>> getting it when reading:
>> http://www.postgresql.org/docs/8.1/interactive/performance-tips.html
>>
>> A bit hard for starters. :-/
>>
>> Any tips/sites?
>>
>
> http://redivi.com/~bob/oscon2005_pgsql_pdf/OSCON_Explaining_Explain_Public.pdf
>
>
> Andreas
>
Thanks Hubert and Andreas!
Looks good.
That will keep me busy for a while. ;-)
Thanks.
Regards,
Erwin Moller
--
-------------------
Erwin Moller
Darwine BV
Groenendaal 25f
3011 SK Rotterdam
tel 010-2133996
-------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marko Kreen | 2007-09-07 12:02:49 | Re: Connection pooling |
| Previous Message | Christian Schröder | 2007-09-07 11:46:23 | Query with "like" is really slow |