Re: checkpoints taking much longer than expected

Поиск
Список
Период
Сортировка
От Tiemen Ruiten
Тема Re: checkpoints taking much longer than expected
Дата
Msg-id CAEkBuzfZT7T3G2j3FLMyzbLNdF13DU1KzH4dyDP0XgkZ3fXUvw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: checkpoints taking much longer than expected  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список pgsql-general
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Rob Nikander
Дата:
Сообщение: Re: Async client libraries - not worth it?
Следующее
От: Dave Cramer
Дата:
Сообщение: Re: Async client libraries - not worth it?