From: | mark <pgroad(at)163(dot)com> |
---|---|
To: | "Alvaro Herrera" <alvherre(at)alvh(dot)no-ip(dot)org> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: postgresql9.5 partition table |
Date: | 2017-12-29 14:05:08 |
Message-ID: | 151a18c0.b4bc.160a2973bc9.Coremail.pgroad@163.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi Herrera
Thanks for your reply.
I will try it in postgresql10.
Regards,
Mark
发自网易邮箱手机版
在2017年12月29日 21:46,Alvaro Herrera 写道:
mark wrote:
> 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?
Postgres 9.5 is not prepared to deal with thousands of partitions.
You can try the improved partitioning with the new syntax introduced in
Postgres 10 -- you may have better luck there. Please test it.
If it still doesn't work, let us know in detail what you tested and how
it failed.
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
From | Date | Subject | |
---|---|---|---|
Next Message | Jeremy Finzel | 2017-12-29 15:44:51 | Mimic parse bind execute in psql? |
Previous Message | Alvaro Herrera | 2017-12-29 13:46:04 | Re: postgresql9.5 partition table |