Herodotos Herodotou <hero@cs.duke.edu> writes:
> On Tue, Sep 22, 2009 at 8:06 PM, Jeff Davis <pgsql@j-davis.com> wrote:
>> I think you mean that the planning time is in milliseconds, not seconds.
> The planning time is actually in seconds.
This is exactly why I think this is a dead-end approach. Trying to do
theorem proving from an unstructured collection of constraints simply
cannot scale to hundreds of partitions, at least not if you want
reasonable planning performance. There are other aspects of our current
partitioning approach that don't scale either, eg the complexity of the
insert redirection triggers. We could handle standard cases where
there's a simple partitioning rule with far less overhead than this,
if we had an explicit model of the partitioning rule inside the system.
regards, tom lane