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 ------------------- ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend