Re: pg_basebackup -F t fails when fsync spends more time thantcp_user_timeout

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: pg_basebackup -F t fails when fsync spends more time thantcp_user_timeout
Дата
Msg-id 20190903015818.GB3765@paquier.xyz
обсуждение исходный текст
Ответ на Re: pg_basebackup -F t fails when fsync spends more time thantcp_user_timeout  (Michael Paquier <michael@paquier.xyz>)
Ответы Re: pg_basebackup -F t fails when fsync spends more time thantcp_user_timeout  (Michael Paquier <michael@paquier.xyz>)
Список pgsql-hackers
On Mon, Sep 02, 2019 at 05:38:56PM +0900, Michael Paquier wrote:
> Thinking wider, don't we have the same problem with wal_sender_timeout
> in the case where a sync request takes longer than the time it would
> take the backend to terminate the connection?

I have been able to work more on that, and that can indeed happen with
wal_sender_timeout.  While reviewing the code, I have noticed that
there is little point to enable do_sync when fetching WAL segments.
This actually led to too many fsyncs done for the plain format as each
WAL segment is fsync'd first by walmethods.c, then fsync'd again by
fsync_pgdata() in pg_wal/.

Attached is an updated patch, which needs to go down to v10.
--
Michael

Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Peter Geoghegan
Дата:
Сообщение: Re: [HACKERS] [WIP] Effective storage of duplicates in B-tree index.
Следующее
От: "Tsunakawa, Takayuki"
Дата:
Сообщение: RE: SIGQUIT on archiver child processes maybe not such a hot idea?