> 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?
Bad RAM? Have you tested it?
Aglio Database Solutions
In response to
pgsql-performance by date
|Next:||From: Garrett Bladow||Date: 2003-09-24 00:41:13|
|Subject: Re: LIKE query running slow|
|Previous:||From: Garrett Bladow||Date: 2003-09-24 00:24:26|
|Subject: LIKE query running slow|