Re: performance problem - Mailing list pgsql-general

From Doug McNaught
Subject Re: performance problem
Date
Msg-id 8765hhqeks.fsf@asmodeus.mcnaught.org
Whole thread Raw
In response to Re: performance problem  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-general
"Rick Gigger" <rick@alpinenetworking.com> writes:

> > That's VERY high.  When postgresql has to manage a lot of buffers it
> > actually is slower than letting the kernel in Linux or BSD do it for you.
>
> Even if you've got the memory to spare?  Does postgres actually slow down
> just because it's slower to manager a lot of them just or because you're
> taking the memory away from the kernel so the kernel has to swap more?

The latter, mainly, I think.  Also you *really* don't want your kernel
to swap out any of your shared buffers, which can happen if they take
up a significant portion of RAM...

-Doug

pgsql-general by date:

Previous
From: "Rick Gigger"
Date:
Subject: Re: performance problem
Next
From: Martijn van Oosterhout
Date:
Subject: Re: performance problem