postgresql9.5 partition table

From: mark <pgroad(at)163(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: postgresql9.5 partition table
Date: 2017-12-29 13:21:09
Message-ID: 4e3519f7.b2f3.160a26ef84f.Coremail.pgroad@163.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I defined a table using 1000 partition tables.
When I deleted or updated this table. It used a lot of memory and postmaster process is killed by OS. When I defined the same table using 100 partition tables. It can normally be updated and deleted. what is reason of this?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2017-12-29 13:46:04 Re: postgresql9.5 partition table
Previous Message Marco Nenciarini 2017-12-29 13:15:22 [PATCH] Logical decoding of TRUNCATE