Re: shared buffers - Mailing list pgsql-general

From Tom Lane
Subject Re: shared buffers
Date
Msg-id 28074.1098738529@sss.pgh.pa.us
Whole thread Raw
In response to shared buffers  (Glenn Sullivan <glenn.sullivan@varianinc.com>)
List pgsql-general
Glenn Sullivan <glenn.sullivan@varianinc.com> writes:
> What is the performance issue with setting shared_buffers to something like 45?
> In doing some timing on my system, I cannot tell any difference with 45 versus 1000.

What are you timing exactly?  Almost every benchmark I've ever seen is
much happier with shared_buffers of at least a few hundred.  Otherwise
you spend too much time copying data between kernel and user space.

            regards, tom lane

pgsql-general by date:

Previous
From: Együd Csaba
Date:
Subject: Error restoring bytea from dump
Next
From: Gaetano Mendola
Date:
Subject: Re: (S)RPMs for PostgreSQL 7.2.6, 7.3.8 and 7.4.6 are ready