Request a Demo
Home   >   mailing lists

Re: plan time of MASSIVE partitioning ... - Mailing list pgsql-hackers

From Leonardo Francalanci
Subject Re: plan time of MASSIVE partitioning ...
Date
Msg-id 570592.14631.qm@web29006.mail.ird.yahoo.com
Whole thread Raw
In response to Re: plan time of MASSIVE partitioning ...  (Leonardo Francalanci <m_lists@yahoo.it>)
List pgsql-hackers
Tree view 
> but I don't get any gain from the patch... explain time is still  around 250
>ms.
> Tried with 9000 partitions, time is still 2  secs.


Small correction: I tried with 3000 partitions (FOR i IN 0..3000 ...)
and got 250ms with both versions, with 9000 partitions 2 secs (again
no gain from the patch)

pgsql-hackers by date:

Previous
From: Leonardo Francalanci
Date:
Subject: Re: plan time of MASSIVE partitioning ...
Next
From: Robert Haas
Date:
Subject: Re: sorted writes for checkpoints