| From: | Tiemen Ruiten <t(dot)ruiten(at)tech-lab(dot)io> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: checkpoints taking much longer than expected |
| Date: | 2019-06-17 12:29:18 |
| Message-ID: | CAEkBuzfZT7T3G2j3FLMyzbLNdF13DU1KzH4dyDP0XgkZ3fXUvw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Sun, Jun 16, 2019 at 8:57 PM Alvaro Herrera <alvherre(at)2ndquadrant(dot)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
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Cramer | 2019-06-17 12:57:37 | Re: Async client libraries - not worth it? |
| Previous Message | Rob Nikander | 2019-06-17 11:35:02 | Re: Async client libraries - not worth it? |