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: (view raw, whole thread or download thread mbox)
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.


In response to


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-2017 The PostgreSQL Global Development Group