Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

Next:From: Tom LaneDate: 2005-08-30 02:16:20
Subject: Re: shared buffers
Previous:From: Carlos Henrique ReimerDate: 2005-08-30 01:54:54
Subject: Re: shared buffers

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group