Re: shared buffers

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Carlos Henrique Reimer <carlosreimer(at)yahoo(dot)com(dot)br>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: shared buffers
Date: 2005-08-30 02:08:21
Message-ID: 4313BF95.3030105@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2005-08-30 02:16:20 Re: shared buffers
Previous Message Carlos Henrique Reimer 2005-08-30 01:54:54 Re: shared buffers