On Mon, Feb 13, 2017 at 7:01 AM, Amit Khandekar <amitdkhan...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers