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?
Next:From: Josh BerkusDate: 2003-09-24 00:35:50
Subject: Re: LIKE query running slow
Previous:From: Vivek KheraDate: 2003-09-23 14:27:55
Subject: Re: restore time: sort_mem vs. checkpoing_segments