Skip site navigation (1) Skip section navigation (2)

Re: plan time of MASSIVE partitioning ...

From: Leonardo Francalanci <m_lists(at)yahoo(dot)it>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Boszormenyi Zoltan <zb(at)cybertec(dot)at>, pgsql-hackers Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: plan time of MASSIVE partitioning ...
Date: 2010-10-29 17:22:12
Message-ID: 131872.8446.qm@web29013.mail.ird.yahoo.com (view raw or flat)
Thread:
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?


      

In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2010-10-29 17:31:32
Subject: Re: plan time of MASSIVE partitioning ...
Previous:From: Robert HaasDate: 2010-10-29 17:16:44
Subject: Re: plan time of MASSIVE partitioning ...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group