[ClusterLabs] PostgreSQL PAF failover issue
t.ruiten at rdmedia.com
Fri Jun 14 09:05:07 EDT 2019
Current size of the database is around 600GB uncompressed (LZ4 compression
is enabled on the ZFS dataset).
On Fri, 14 Jun 2019 at 14:59, Tiemen Ruiten <t.ruiten at rdmedia.com> wrote:
> 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
>> shared_buffers? What kind of hardware do you use (baremetal,
> Tiemen Ruiten
> Systems Engineer
> R&D Media
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Users