Horton

Re: plan time of MASSIVE partitioning ...

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Leonardo Francalanci <m_lists@yahoo.it>
Cc: Boszormenyi Zoltan <zb@cybertec.at>, pgsql-hackers Hackers <pgsql-hackers@postgresql.org>
Date: 2010-10-29T17:31:32Z
Lists: pgsql-hackers 
Leonardo Francalanci <m_lists@yahoo.it> writes:
> BTW can someone explain to me which are the cases where the
> patch actually helps?

Cases with lots of irrelevant indexes.  Zoltan's example had 4 indexes
per child table, only one of which was relevant to the query.  In your
test case there are no irrelevant indexes, which is why the runtime
didn't change.

			regards, tom lane