Re: Vectored I/O in bulk_write.c

Поиск
Список
Период
Сортировка
От Thomas Munro
Тема Re: Vectored I/O in bulk_write.c
Дата
Msg-id CA+hUKGKOsSvGcwDQP3sCmRT-wbwmxOfo53O2VhVbnk8xpuXwWQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Vectored I/O in bulk_write.c  (Thomas Munro <thomas.munro@gmail.com>)
Ответы Re: Vectored I/O in bulk_write.c  (Thomas Munro <thomas.munro@gmail.com>)
Список pgsql-hackers
Here also is a first attempt at improving the memory allocation and
memory layout.

I wonder if bulk logging should trigger larger WAL writes in the "Have
to write it ourselves" case in AdvanceXLInsertBuffer(), since writing
8kB of WAL at a time seems like an unnecessarily degraded level of
performance, especially with wal_sync_method=open_datasync.  Of course
the real answer is "make sure wal_buffers is high enough for your
workload" (usually indirectly by automatically scaling from
shared_buffers), but this problem jumps out when tracing bulk_writes.c
with default settings.  We write out the index 128kB at a time, but
the WAL 8kB at a time.

Вложения

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

Предыдущее
От: jian he
Дата:
Сообщение: Re: Adding OLD/NEW support to RETURNING
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: Hooking into ExplainOneQuery() complicated by missing standard_ExplainOneQuery