From: Jesper Pedersen <jesper.pedersen@redhat.com>
To: Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Cc: Alvaro Herrera <alvherre@2ndquadrant.com>
Cc: David Rowley <david.rowley@2ndquadrant.com>
Cc: Amit Langote <amitlangote09@gmail.com>
Cc: Imai, Yoshikazu <imai.yoshikazu@jp.fujitsu.com>
Cc: Pg Hackers <pgsql-hackers@postgresql.org>
Subject: Re: speeding up planning with partitions
Date: Mon, 21 Jan 2019 09:40:28 -0500
Message-ID: <ec2483c1-15a1-08f8-70a3-50aef7575317@redhat.com> (raw)
In-Reply-To: <9e1cf3fb-e7eb-6bda-126f-df11823293de@lab.ntt.co.jp>
References: <201901161932.c6oxfxckbnyo@alvherre.pgsql>
<b6e39c7a-7dc6-5e98-94aa-22b30688e50e@lab.ntt.co.jp>
<9e1cf3fb-e7eb-6bda-126f-df11823293de@lab.ntt.co.jp>
Hi,
On 1/21/19 4:01 AM, Amit Langote wrote:
> Rebased again due to 8d8dcead1295.
>
Passes check-world on 8d8dcead1295.
I ran a work load on the series, measuring the time to load the data
plus the run-time to complete the work load.
Load Run
master 3m39s 144s
1778 3m12s 36s
NP [*] 2m20s 11s
[*] Non partitioned case.
Best regards,
Jesper
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: jesper.pedersen@redhat.com, Langote_Amit_f8@lab.ntt.co.jp, alvherre@2ndquadrant.com, david.rowley@2ndquadrant.com, amitlangote09@gmail.com, imai.yoshikazu@jp.fujitsu.com
Subject: Re: speeding up planning with partitions
In-Reply-To: <ec2483c1-15a1-08f8-70a3-50aef7575317@redhat.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox