Hello,
On Wed, Aug 13, 2014 at 5:28 PM, Marti Raudsepp ma...@juffo.org wrote:
On Wed, Aug 13, 2014 at 9:44 AM, Albe Laurenz laurenz.a...@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
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 MD3200
On Wed, Aug 13, 2014 at 9:44 AM, Albe Laurenz laurenz.a...@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
--
Sent via
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