Re: postgresql9.5 partition table

2017-12-29 Thread mark
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. Wh

Re: postgresql9.5 partition table

2017-12-29 Thread 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? Postg

postgresql9.5 partition table

2017-12-29 Thread mark
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?