On 9/18/06, Jérôme BENOIS <benois@xxxxxxxxxxxxxxxxxxxx> wrote:
Tomorrow morning i plan to add 2Go RAM in order to test difference with
my actual config.
I don't think more RAM will change anything if you don't swap at all.
You can try to set shared_buffers lower (try 32768 and 16384) but I
don't think it will change anything in 8.1.
The only thing left IMHO is that 8.1 is choosing a bad plan which
consumes a lot of CPU for at least a query.
When you analyze your logs, did you see a particularly slow query? Can
you compare query log analysis from your old server and your new one?
--
Guillaume
