Re: Non-linear Performance

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Curt Sampson <cjs(at)cynic(dot)net>
Cc: Doug Fields <dfields-pg-general(at)pexicom(dot)com>, "Peter A(dot) Daly" <petedaly(at)ix(dot)netcom(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Non-linear Performance
Date: 2002-05-31 14:42:28
Message-ID: 17977.1022856148@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Curt Sampson <cjs(at)cynic(dot)net> writes:
> What is the advantage, if any, to having postgres do the buffering
> in its shared memory rather than letting the OS do it?

Not much, if any. I don't believe in making shared_buffers be more than
(at most) 25% of physical RAM. In most cases it's just as effective to
keep it smaller. I would recommend bumping up the default though ;-).
Something in the low thousands (of buffers) is probably a realistic
minimum.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-05-31 14:47:08 Re: sort_mem sizing (Non-linear Performance)
Previous Message Oleg Bartunov 2002-05-31 14:38:47 Re: PostgreSQL search engine (Perl)