Re: performance problem

Douglas McNaught <doug@mcnaught.org>

From: Doug McNaught <doug@mcnaught.org>
To: "Rick Gigger" <rick@alpinenetworking.com>
Cc: "scott.marlowe" <scott.marlowe@ihs.com>, "PgSQL General ML" <pgsql-general@postgresql.org>
Date: 2003-11-19T02:25:55Z
Lists: 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