Re: [POC] Faster processing at Gather node

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
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

In response to

Browse pgsql-hackers by date

  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