| From: | Doug McNaught <doug(at)mcnaught(dot)org> |
|---|---|
| To: | "Rick Gigger" <rick(at)alpinenetworking(dot)com> |
| Cc: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>, "PgSQL General ML" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: performance problem |
| Date: | 2003-11-19 02:25:55 |
| Message-ID: | 8765hhqeks.fsf@asmodeus.mcnaught.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general |
"Rick Gigger" <rick(at)alpinenetworking(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martijn van Oosterhout | 2003-11-19 02:30:56 | Re: performance problem |
| Previous Message | Joshua D. Drake | 2003-11-19 00:55:14 | Re: Point-in-time data recovery - v.7.4 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martijn van Oosterhout | 2003-11-19 02:30:56 | Re: performance problem |
| Previous Message | Tom Lane | 2003-11-19 01:32:59 | Re: Query Planner Filtering Of Specified Value From 'On Distinct' Clause |