Re: Declarative partitioning grammar - Mailing list pgsql-hackers

From Warren Turkal
Subject Re: Declarative partitioning grammar
Date
Msg-id 8c3d85470801111616l2d21a146p11d2bbf579d187cf@mail.gmail.com
Whole thread Raw
In response to Re: Declarative partitioning grammar  (Ron Mayer <rm_pg@cheapcomplexdevices.com>)
Responses Re: Declarative partitioning grammar  (Jeff Cohen <jcohen@greenplum.com>)
List pgsql-hackers
On Jan 11, 2008 3:42 PM, Ron Mayer <rm_pg@cheapcomplexdevices.com> wrote:
> What would be the drawbacks of
>   CREATE TABLE tablename(...)
>   PARTITION BY function_taking_row_returning_partition_name
> instead of the explicit types?

Would that still allow the optimizer to work as well as it could? It
seems that an arbitrary map like that can't be optimized very well as
it might be too general.

wt


pgsql-hackers by date:

Previous
From: Mike
Date:
Subject: Re: Declarative partitioning grammar
Next
From: Tom Lane
Date:
Subject: Re: Transaction Snapshot Cloning