Re: shared buffers - Mailing list pgsql-performance

From Christopher Kings-Lynne
Subject Re: shared buffers
Date
Msg-id 4313BF95.3030105@familyhealth.com.au
Whole thread Raw
In response to Re: shared buffers  (Carlos Henrique Reimer <carlosreimer@yahoo.com.br>)
List pgsql-performance
> I forgot to say that it´s a 12GB database...

That's actually not that large.

> Ok, I´ll set shared buffers to 30.000 pages but even so "meminfo" and
> "top" shouldn´t show some shared pages?

Yeah. The reason for not setting buffers so high is because PostgreSQL
cannot efficiently manage huge shared buffers, so you're better off
giving the RAM to Linux's disk cache.

Chris


pgsql-performance by date:

Previous
From: Carlos Henrique Reimer
Date:
Subject: Re: shared buffers
Next
From: Tom Lane
Date:
Subject: Re: shared buffers