> 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 Lane||Date: 2005-08-30 02:16:20|
|Subject: Re: shared buffers |
|Previous:||From: Carlos Henrique Reimer||Date: 2005-08-30 01:54:54|
|Subject: Re: shared buffers|