"Dave Weaver" <[EMAIL PROTECTED]> writes: > Is the upgrade likely to make a difference?
I'm not sure if it would help for this specific query, but in general each major PG release has useful performance improvements over the previous one. What I'm wondering about is an index-bloat problem (see the pgsql-performance archives for discussions). Do you do a lot of updates or deletes on this table, or is it just inserts? What is the physical size of the table and its index? The output of VACUUM VERBOSE for this table would be useful to show. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend