Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: plan time of MASSIVE partitioning ...
Date
Msg-id 4207.1288373492@sss.pgh.pa.us
Whole thread Raw
In response to Re: plan time of MASSIVE partitioning ...  (Leonardo Francalanci <m_lists@yahoo.it>)
Responses Re: plan time of MASSIVE partitioning ...  (Leonardo Francalanci <m_lists@yahoo.it>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Leonardo Francalanci
Date:
Subject: Re: plan time of MASSIVE partitioning ...
Next
From: Tom Lane
Date:
Subject: Re: plan time of MASSIVE partitioning ...