Re: shared_buffers and shmmax what are the max recommended values?

From: "Anton Melser" <melser(dot)anton(at)gmail(dot)com>
To: "Greg Smith" <gsmith(at)gregsmith(dot)com>
Cc: "Postgres General" <pgsql-general(at)postgresql(dot)org>
Subject: Re: shared_buffers and shmmax what are the max recommended values?
Date: 2008-03-07 14:45:07
Message-ID: 92d3a4950803070645p4f086252g9e06e34db4748501@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

> With 6GB of RAM, after that you could merrily increase shared_buffers to
> 200000 or so and possibly increase performance. Just watch your
> checkpoints--they'll have more activity as you increase the buffer size,
> and from your description you've still got checkpoint_segments at the tiny
> default size. You say this is a web app, those typically aren't write
> heavy so you'll probably be OK.

Thanks, I'll get onto that...
There is actually quite a bit of write (at least the dump is
increasing far more than what is being added manually by content
writers... and I'm not even certain where it is coming from but that
is another story!), and yes checkpoint_segments is at the default...
if I increase to 10 or so will that be better?
btw, we have a warm standby via wal copies if that makes a difference...
Cheers
Anton

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tonton Dede 2008-03-07 14:49:39 pg_standby for solaris x86
Previous Message Scott Ribe 2008-03-07 14:43:10 Re: JOIN and difference between timestamps

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2008-03-07 14:51:43 Re: Idea: Comments on system catalogs?
Previous Message Bruce Momjian 2008-03-07 14:42:12 Re: Commitfest status