| From: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
|---|---|
| To: | mark <pgroad(at)163(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: postgresql9.5 partition table |
| Date: | 2017-12-29 13:46:04 |
| Message-ID: | 20171229134604.2sqdt56sfhtknkct@alvherre.pgsql |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 | mark | 2017-12-29 14:05:08 | Re: postgresql9.5 partition table |
| Previous Message | mark | 2017-12-29 13:21:09 | postgresql9.5 partition table |