Horton

Re: plan time of MASSIVE partitioning ...

Leonardo Francalanci <m_lists@yahoo.it>

View thread
From: Leonardo Francalanci <m_lists@yahoo.it>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Boszormenyi Zoltan <zb@cybertec.at>, pgsql-hackers Hackers <pgsql-hackers@postgresql.org>
Date: 2010-10-29T17:22:12Z
Lists: pgsql-hackers 
> Hmm, maybe I spoke too soon.  With 9000 child tables I get  a profile
> like this:


Well, the 9000-table-test-case was meant to check the difference in
performance with/without the patch... I don't see the reason for trying
to optimize such an unrealistic case.

BTW can someone explain to me which are the cases where the
patch actually helps?