Postgres Pro
Downloads
Home   >   mailing lists

Re: checkpoints taking much longer than expected - Mailing list pgsql-general

From Peter J. Holzer
Subject Re: checkpoints taking much longer than expected
Date
Msg-id 20190614162209.7ek4xt5uxcaw4jho@hjp.at
Whole thread Raw
In response to checkpoints taking much longer than expected  (Tiemen Ruiten <t.ruiten@tech-lab.io>)
Responses Re: checkpoints taking much longer than expected
List pgsql-general
Tree view 
On 2019-06-14 16:01:40 +0200, Tiemen Ruiten wrote:
> FS is ZFS, the dataset with the PGDATA directory on it has the following
> properties (only non-default listed):
[...]
> My problem is that checkpoints are taking a long time. Even when I run a few
> manual checkpoints one after the other, they keep taking very long, up to 10
> minutes:

There was a discussion about ZFS' COW behaviour and PostgreSQL reusing
WAL files not being a good combination about a year ago:
https://www.postgresql.org/message-id/flat/CACukRjO7DJvub8e2AijOayj8BfKK3XXBTwu3KKARiTr67M3E3w%40mail.gmail.com

Maybe you have the same problem?

        hp

--
   _  | Peter J. Holzer    | we build much bigger, better disasters now
|_|_) |                    | because we have much more sophisticated
| |   | hjp@hjp.at         | management tools.
__/   | http://www.hjp.at/ | -- Ross Anderson <https://www.edge.org/>
Attachment

pgsql-general by date:

Previous
From: Stephen Frost
Date:
Subject: Re: checkpoints taking much longer than expected
Next
From: Shane Duan
Date:
Subject: PostgreSQL 10 and OpenSSL 1.1