On Mon, Feb 13, 2017 at 7:01 AM, Amit Khandekar <amitdkhan.pg@gmail.com> wrote:
> parts partitioned inheritance no. of rows subpartitions
> ===== =========== =========== =========== =============
>
> 500 10 sec 3 min 02 sec 1,000,000 0
> 1000 10 sec 3 min 05 sec 1,000,000 0
> 1000 1 min 38sec 30min 50 sec 10,000,000 0
> 4000 28 sec 5 min 41 sec 1,000,000 10
That's a big speedup.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company