[PERFORM] Force table to be permanently in cache?

Hi everyone, I have a sql request which on first invocation completes in ~12sec but then drops to ~3sec on the following runs. The 3 seconds would be acceptable but how can I make sure that the data is cached and all times? Is it simply enough to set shared_buffers high enough to hold the

Re: [PERFORM] Force table to be permanently in cache?

On Fri, Aug 29, 2003 at 02:52:10PM +0200, Fabian Kreitner wrote: Hi everyone, I have a sql request which on first invocation completes in ~12sec but then drops to ~3sec on the following runs. The 3 seconds would be acceptable but how can I make sure that the data is cached and all times?