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