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
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