Postgres Pro
Downloads
Home   >   mailing lists

Re: [report] memory leaks in COPY FROM on partitioned table - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: [report] memory leaks in COPY FROM on partitioned table
Date
Msg-id 20180724014308.GB4035@paquier.xyz
Whole thread Raw
In response to [report] memory leaks in COPY FROM on partitioned table  (Kohei KaiGai <kaigai@heterodb.com>)
Responses Re: [report] memory leaks in COPY FROM on partitioned table  (Kohei KaiGai <kaigai@heterodb.com>)
List pgsql-hackers
Tree view 
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
Attachment

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Fix calculations on WAL recycling.
Next
From: Michael Paquier
Date:
Subject: Re: pgbench: improve --help and --version parsing