Re: Serious performance problems with large BUFPOOLSIZE

[Richard Sims]

On Jan 27, 2006, at 1:54 PM, Allen S. Rout wrote:

Sounds like that would make a fascinating chart.

And the recommended formula would have led you to something like 20G,
right?

With the really slow points, was the cache hit percentage good?

Something else that could be interesting is to set server option

    SELFTUNEBUFpoolsize Yes

and see what the server comes up with as its own value.

       Richard Sims