[PERFORM] LIKE query running slow

2003-09-23 Thread Garrett Bladow
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? -Garrett Bladow ---(end

Re: [PERFORM] LIKE query running slow

2003-09-24 Thread Garrett Bladow
On Tue, 23 Sep 2003, Josh Berkus wrote: Garrett, 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?