Hello,
On Wed, Aug 13, 2014 at 5:28 PM, Marti Raudsepp wrote:
> On Wed, Aug 13, 2014 at 9:44 AM, Albe Laurenz
> 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
On Wed, Aug 13, 2014 at 9:44 AM, Albe Laurenz 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
--
Sent via pgsql-general mailing list (pgs
dushy wrote:
> Iam running a postgresql 9.0.13 master/slave instance in a write heavy
> workload.
>
> The hardware is a Dell 720, E5530 - 8 core, 128GB RAM. The database (around
> 250g with indexes/bloat etc) is sitting on flashcache device with 2 fusion-
> io PCIe MLC SSDs as frontend and a MD320
Hello all,
Iam running a postgresql 9.0.13 master/slave instance in a write heavy
workload.
The hardware is a Dell 720, E5530 - 8 core, 128GB RAM. The database (around
250g with indexes/bloat etc) is sitting on flashcache device with 2 fusion-
io PCIe MLC SSDs as frontend and a MD3200 based RA
