[PERFORM] SELECT performance problem

I am updating from 7.4.5 to 8.2.3. I have noticed a significant slowdown in simple searches such as "select filename from vnmr_data where seqfil = 'sems';" This returns 12 rows out of 1 million items in the table. On 7.4.5, this takes about 1.5 seconds. On 8.2.3, it is taking about 9 seconds

Re: [PERFORM] Performance of ORDER BY

Thanks to Luke and Tom for the input.  I guess this was good timing given that it looks like 8.2 was just released today.   I will upgade to that before doing anything else. Glenn Tom Lane wrote: Glenn Sullivan <[EMAIL PROTECTED]> writes: I am wanting some ideas about imp

[PERFORM] Performance of ORDER BY

I am wanting some ideas about improving the performance of ORDER BY in our use. I have a DB on the order of 500,000 rows and 50 columns. The results are always sorted with ORDER BY. Sometimes, the users end up with a search that matches most of the rows. In that case, I have a LIMIT 5000 to kee