If, like me, you came from the Oracle world, you may be tempted to throw a ton of RAM at this. Don't. PG does not like it.
On Fri, May 28, 2010 at 4:11 PM, Scott Marlowe <scott.marl...@gmail.com>wrote: > On Mon, May 24, 2010 at 12:25 PM, Merlin Moncure <mmonc...@gmail.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. > > -- > Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-performance >
