From: | Rafia Sabih <rafia(dot)sabih(at)enterprisedb(dot)com> |
---|---|
To: | Andres Freund <andres(at)anarazel(dot)de> |
Cc: | PostgreSQL Developers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: [POC] Faster processing at Gather node |
Date: | 2017-10-17 05:01:32 |
Message-ID: | CAOGQiiOPxLJL2kNgd4oXgP+ityTNki=wi=uy3X=M78e5Vpak8Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Tue, Oct 17, 2017 at 3:22 AM, Andres Freund <andres(at)anarazel(dot)de> wrote:
> Hi Rafia,
>
> On 2017-05-19 17:25:38 +0530, Rafia Sabih wrote:
>> head:
>> explain analyse select * from t where i < 30000000;
>> QUERY PLAN
>
> Could you share how exactly you generated the data? Just so others can
> compare a bit better with your results?
>
Sure. I used generate_series(1, 10000000);
Please find the attached script for the detailed steps.
--
Regards,
Rafia Sabih
EnterpriseDB: http://www.enterprisedb.com/
Attachment | Content-Type | Size |
---|---|---|
large_tbl_gen.sql | application/octet-stream | 150 bytes |
From | Date | Subject | |
---|---|---|---|
Next Message | Justin Pryzby | 2017-10-17 06:33:11 | Re: SIGSEGV in BRIN autosummarize |
Previous Message | Masahiko Sawada | 2017-10-17 04:41:06 | Re: Block level parallel vacuum WIP |