Re: [GENERAL] (Solved) Decreasing performance in table partitioning

2014-09-16 Thread Huang, Suya
That’s a good idea, thanks for sharing Herouth! From: Herouth Maoz [mailto:hero...@unicell.co.il] Sent: Tuesday, September 16, 2014 10:22 PM To: Huang, Suya Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] (Solved) Decreasing performance in table partitioning Thank you. My solution is

Re: [GENERAL] (Solved) Decreasing performance in table partitioning

2014-09-16 Thread Herouth Maoz
Thank you. My solution is based on your suggestion, but instead of creating a new partition table and inserting into it, I create partitions as I originally planned, under the existing table, and insert to them. But without deleting. I use INSERT INTO... SELECT ONLY, without deleting, and so the