[PERFORM] EXPLAIN ANALYZE much slower than running query normally
- Thanks in advance for any clues. Chris Hutchinson ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
[PERFORM] 'best practises' to speed up sorting? tuning postgresql.conf
by eliminating a left join and ORDER BY, but it would be nice to speed it up further. The time goes up to nearly 6 minutes if I put the ORDER BY back into the query. Any suggestions gratefully received. Regards, Chris Hutchinson --