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

Re: shared_buffers advice

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Merlin Moncure <mmoncure(at)gmail(dot)com>
Cc: Paul McGarry <paul(at)paulmcgarry(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: shared_buffers advice
Date: 2010-05-28 21:11:15
Message-ID: AANLkTimx575uA5FTOPez9qWlpD1fEfSpzic-gY1-mB0p@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
On Mon, May 24, 2010 at 12:25 PM, Merlin Moncure <mmoncure(at)gmail(dot)com> wrote:
> *) shared_buffers is one of the _least_ important performance settings
> in postgresql.conf

Yes, and no.  It's usually REALLY helpful to make sure it's more than
8 or 24Megs.  But it doesn't generally need to be huge to make a
difference.

In response to

Responses

pgsql-performance by date

Next:From: Dave CrookeDate: 2010-05-28 21:14:18
Subject: Re: shared_buffers advice
Previous:From: Greg SmithDate: 2010-05-28 21:02:48
Subject: Re: shared_buffers advice

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