| From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
|---|---|
| To: | Amit Khandekar <amitdkhan(dot)pg(at)gmail(dot)com> |
| Cc: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: UPDATE of partition key |
| Date: | 2017-02-14 14:44:11 |
| Message-ID: | CA+Tgmoawo5e4Vi7M3WOUQwUzR9hoQRGSUGo4GrosJ3hsCncx3Q@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Mon, Feb 13, 2017 at 7:01 AM, Amit Khandekar <amitdkhan(dot)pg(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2017-02-14 16:48:18 | Re: Parallel bitmap heap scan |
| Previous Message | Robert Haas | 2017-02-14 14:41:34 | Re: Small improvement to parallel query docs |