Re: OOM-killer issue when updating a inheritance table which has large number of child tables

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: chenhj <chjischj(at)163(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: OOM-killer issue when updating a inheritance table which has large number of child tables
Date: 2015-03-12 14:00:40
Message-ID: 10837.1426168840@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

chenhj <chjischj(at)163(dot)com> writes:
> In my test(PG9.3.4), i found when update a parent table which has a large number of child tables, the execute plan will consume lots of memory. And possibly cause OOM.

See
file:///net/sss1/home/postgres/pgsql/doc/src/sgml/html/ddl-partitioning.html#DDL-PARTITIONING-CAVEATS

particularly the last paragraph.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2015-03-12 14:07:51 Re: logical column ordering
Previous Message Tom Lane 2015-03-12 13:57:29 Re: shebang for tcl postgresql modules