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 ha

Re: [PERFORM] LIKE query running slow

2003-09-24 Thread Josh Berkus
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? Bad RAM? Have you tested it? -- -Josh Berk

Re: [PERFORM] LIKE query running slow

2003-09-24 Thread Rod Taylor
On Tue, 2003-09-23 at 20:24, 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? W

Re: [PERFORM] LIKE query running slow

2003-09-24 Thread Dennis Bjorklund
On Tue, 23 Sep 2003, 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. If you mean that you reinstalled postgresql then it's pro

Re: [PERFORM] LIKE query running slow

2003-09-24 Thread Jeff
On Tue, 23 Sep 2003, 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? > Did you

Re: [PERFORM] LIKE query running slow

2003-09-24 Thread Shridhar Daithankar
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 se

[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 of broadcast