Hi all!
> - checkpoint_segments 1000
> - checkpoint_completion_target 0.9
> - wal_buffers 256MB
> - shared_buffers 31 gb
> - max_connections 500
I see that some of you are using wal_buffers = 256MB.
I was under the impression that Postgres will not benefit from higher value
than the segment siz
Hi Pavy!
What kernel version/RHEL release are you running on the servers you are
experiencing these issues?
I'm interested in knowing since I suspect similar issues on some of our
database servers.
Best regards, Martin
> -Original Message-
> From: pgsql-performance-ow...@postgresql.org
> >
> > I would also make sure to check that the hypervisor does write to
> permanent storage before returning to the VM with acknowledgement.
> >
> In the case of ESX, there is no such concern per
> http://kb.vmware.com/kb/1008542.
Very useful info!
> As Heikki commented, VMware recently comp
Hi!
We have virtualized several hundreds of production databases, mostly Oracle
and DB2 but a few postgres as well, and we have seen a very positive effect in
doing this.
We might loose a little bit in virtualization overhead but have gained a lot in
flexibility and managebility.
My tips are t
