Re: [report] memory leaks in COPY FROM on partitioned table

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: [report] memory leaks in COPY FROM on partitioned table
Дата
Msg-id 20180724014308.GB4035@paquier.xyz
обсуждение исходный текст
Ответ на [report] memory leaks in COPY FROM on partitioned table  (Kohei KaiGai <kaigai@heterodb.com>)
Ответы Re: [report] memory leaks in COPY FROM on partitioned table  (Kohei KaiGai <kaigai@heterodb.com>)
Список pgsql-hackers
On Tue, Jul 24, 2018 at 09:41:52AM +0900, Kohei KaiGai wrote:
> In PG11beta2, my backend process gets terminated during COPY FROM of
> large text file (544GB) on partitioned table.
> The kernel log says OOM Killer send SIGKILL due to memory pressure.
> In fact, 63GB of system physical 64GB was consumed by the PostgreSQL
> backend just before the termination.

Hmm..  That's not nice.  Let's add an open item.
--
Michael

Вложения

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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: Fix calculations on WAL recycling.
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: pgbench: improve --help and --version parsing