On Jun 16, 2006, at 9:52 AM, Ragnar wrote:
show us the output of EXPLAIN ANALYZE <yourquery>, along with details about relevant columns, indexes, so that we can give more concrete advice.
Better yet, post that to pgsql-performance, which is the most appropriate list for this kind of thing.
-- Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
