COPY and heap_sync

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема COPY and heap_sync
Дата
Msg-id CAMkU=1z0YBPi6Svpji8WBd6vABVQ_+Opm2HyDnJQ07Y32av0-Q@mail.gmail.com
обсуждение исходный текст
Ответы Re: COPY and heap_sync  (Amit Kapila <amit.kapila16@gmail.com>)
Re: COPY and heap_sync  (Peter Eisentraut <peter_e@gmx.net>)
Re: COPY and heap_sync  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
If you insert tuples with COPY into a table created or truncated in the same transaction, at the end of the COPY it calls heap_sync.

But there cases were people use COPY in a loop with a small amount of data in each statement.  Now it is calling heap_sync many times, and if NBuffers is large doing that gets very slow.

Could the heap_sync be safely delayed until the end of the transaction, rather than the end of the COPY?

Cheers,

Jeff

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

Предыдущее
От: Amit Kapila
Дата:
Сообщение: Re: ALTER SYSTEM RESET?
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: Misleading error message in logical decoding for binary plugins