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 jnasby@pervasive.com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461