> Glenn Sullivan
> Sent: Tuesday, February 20, 2007 5:22 PM
> To: pgsql-performance@postgresql.org
> Subject: [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
> &
On Tue, 20 Feb 2007, Glenn Sullivan wrote:
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 seco
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
