Horton

Re: plan time of MASSIVE partitioning ...

Leonardo Francalanci <m_lists@yahoo.it>

View thread
From: Leonardo Francalanci <m_lists@yahoo.it>
To: Leonardo Francalanci <m_lists@yahoo.it>, Boszormenyi Zoltan <zb@cybertec.at>, Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-hackers Hackers <pgsql-hackers@postgresql.org>
Date: 2010-10-29T08:57:20Z
Lists: pgsql-hackers 
> 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)