Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres 9.3 tuning advice - Mailing list pgsql-general

From Marti Raudsepp
Subject Re: Postgres 9.3 tuning advice
Date
Msg-id CABRT9RAyLHYKJuJRTBwccZu=jGe6_UgzWs+2sd4YtEyp8tZSdA@mail.gmail.com
Whole thread Raw
In response to Re: Postgres 9.3 tuning advice  (Albe Laurenz <laurenz.albe@wien.gv.at>)
Responses Re: Postgres 9.3 tuning advice  (dushy <dushyanth@gmail.com>)
List pgsql-general
Tree view 
On Wed, Aug 13, 2014 at 9:44 AM, Albe Laurenz <laurenz.albe@wien.gv.at> wrote:
> Set wal_buffers to 16MB so that a whole WAL segment will fit.

No need, wal_buffers is automatically tuned now. If your
shared_buffers is 512MB or larger, wal_buffers will be 16MB.

Regards,
Marti

pgsql-general by date:

Previous
From: Soni M
Date:
Subject: Re: Can I see the detailed log of query fired by particular Postgres client on Postgres server?
Next
From: Jimmy Thrasibule
Date:
Subject: Re: PostgreSQL as a triple store