[ClusterLabs] PostgreSQL PAF failover issue
t.ruiten at rdmedia.com
Fri Jun 14 08:59:01 EDT 2019
Hi, yes I'm also puzzled by this. The cluster is certainly not
underpowered, running on baremetal with 8x SSD in ZFS stripe of mirrors,
128 GB RAM and shared_buffers is set to 8GB.
other related settings:
wal_buffers = 128MB
checkpoint_timeout = 60min
max_wal_size = 8GB
min_wal_size = 1GB
checkpoint_completion_target = 0.9
I wonder if checkpoint_timeout should be lowered?
On Fri, 14 Jun 2019 at 14:49, Adrien Nayrat <adrien.nayrat at anayrat.info>
> On 6/14/19 12:27 PM, Tiemen Ruiten wrote:
> > This took longer than the configured timeout of 60s (checkpoint hadn't
> > yet) and the node was fenced.
> That's surprising checkpoint took longer than 60s. What is the size of your
> shared_buffers? What kind of hardware do you use (baremetal,
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Users