On Thu, Mar 12, 2015 at 06:55:48PM +0800, chenhj wrote: > Hi > > 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.
At the moment, partitioning into thousands of tables is not supported. If you can reproduce the problem in PostgreSQL 9.3.6, or whichever happens to be the most recent minor version by the time you do the test, that will help. Just generally, it helps to provide a complete test case which reproduces the problem if at all possible. Cheers, David. -- David Fetter <da...@fetter.org> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
