Postgres Pro
Downloads
Home   >   mailing lists

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

From Tiemen Ruiten
Subject Re: checkpoints taking much longer than expected
Date
Msg-id CAEkBuzfZT7T3G2j3FLMyzbLNdF13DU1KzH4dyDP0XgkZ3fXUvw@mail.gmail.com
Whole thread Raw
In response to Re: checkpoints taking much longer than expected  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-general
Tree view
On Sun, Jun 16, 2019 at 8:57 PM Alvaro Herrera <alvherre@2ndquadrant.com> wrote:
On 2019-Jun-14, Peter J. Holzer wrote:

> 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?

Note that Joyent ended up proposing patches to fix their performance
problem (and got them committed).  Maybe it would be useful for Tiemen
to try that code?  (That commit cherry-picks cleanly on REL_11_STABLE.)

Unfortunately it doesn't compile:

access/transam/xlog.o: In function `XLogFileInit':
/home/ter/rpmbuild/BUILD/postgresql-11.3/src/backend/access/transam/xlog.c:3299: undefined reference to `pg_pwrite'
collect2: error: ld returned 1 exit status
 


--
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


pgsql-general by date:

Previous
From: Rob Nikander
Date:
Subject: Re: Async client libraries - not worth it?
Next
From: Dave Cramer
Date:
Subject: Re: Async client libraries - not worth it?