Обсуждение: Tutorial EXPLAIN for idiots?
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? TIA Regards, Erwin -- ------------------- Erwin Moller Darwine BV Groenendaal 25f 3011 SK Rotterdam tel 010-2133996 -------------------
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 -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net
On Fri, Sep 07, 2007 at 12:30:06PM +0200, Erwin Moller wrote: > Any tips/sites? check this: http://www.postgresql.org/communityfiles/13.sxi depesz -- quicksil1er: "postgres is excellent, but like any DB it requires a highly paid DBA. here's my CV!" :) http://www.depesz.com/ - blog dla ciebie (i moje CV)
A. Kretschmer wrote:
Thanks Hubert and Andreas!
Looks good.
That will keep me busy for a while. ;-)
Thanks.
Regards,
Erwin Moller
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 -------------------