[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: postgresql9.5 partition table
From:       mark <pgroad () 163 ! com>
Date:       2017-12-29 14:05:08
Message-ID: 151a18c0.b4bc.160a2973bc9.Coremail.pgroad () 163 ! com
[Download RAW message or body]

[Attachment #2 (text/plain)]

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

[Attachment #3 (text/html)]

<div style="line-height:1.6;font-size:16px;font-family:'苹方','微软雅黑','sans-serif';">Hi \
Herrera<br>Thanks for your reply.<br>I will try it in \
postgresql10.<br>Regards,<br>Mark<br><br>发自网易邮箱手机版<br><br></div><div \
class="ne-quoted"><blockquote id="ntes-andriodmail-quote" style="margin:0px \
!important;padding:0px !important;border: none !important;"><div class="J-reply" \
style="background-color:#f2f2f2;color:black;padding-top:6px;padding-bottom:6px;border- \
radius:3px;-moz-border-radius:3px;-webkit-border-radius:3px;margin-top:45px;margin-bottom:20px;">
  <div style="font-size:14px;line-height:1.5;word-break:break-all;margin-left:10px;margin-right:10px">在<span \
class="mail-date">2017年12月29日 21:46</span>，<a class="mail-to" \
style="text-decoration:none;color:#2a97ff;" \
href="mailto:alvherre@alvh.no-ip.org">Alvaro Herrera</a> 写道：</div> </div>mark \
wrote: <br>&gt; I defined a table using 1000 partition tables.
<br>&gt; When I deleted or updated this table. It used a lot of memory and
<br>&gt; postmaster process is killed by OS. When I defined the same table
<br>&gt; using 100 partition tables. It can normally be updated and deleted.
<br>&gt; what is reason of this?
<br>
<br>Postgres 9.5 is not prepared to deal with thousands of partitions.
<br>
<br>You can try the improved partitioning with the new syntax introduced in
<br>Postgres 10 -- you may have better luck there. &nbsp;Please test it.
<br>If it still doesn't work, let us know in detail what you tested and how
<br>it failed.
<br>
<br>-- 
<br>Álvaro Herrera &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<a \
href="https://www.2ndQuadrant.com/">https://www.2ndQuadrant.com/</a> <br>PostgreSQL \
Development, 24x7 Support, Remote DBA, Training &amp; Services \
<br></blockquote></div>



[prev in list] [next in list] [prev in thread] [next in thread]