Garrett Bladow wrote:
> Recently we upgraded the RAM in our server. After the install a LIKE query that used to take 5 seconds now takes 5 minutes. We have tried the usual suspects, VACUUM, ANALYZE and Re-indexing.
> Any thoughts on what might have happened?
What all tuning you have done? Have you set effective cache size to take care of
Just check out.
In response to
pgsql-performance by date
|Next:||From: Manfred Koizar||Date: 2003-09-24 09:14:19|
|Subject: Re: osdl-dbt3 run results - puzzled by the execution|
|Previous:||From: peter||Date: 2003-09-24 05:48:15|
|Subject: Performance issue|