Re: Declarative partitioning grammar

Warren Turkal <turkal@google.com>

From: "Warren Turkal" <turkal@google.com>
To: "Ron Mayer" <rm_pg@cheapcomplexdevices.com>
Cc: "Gavin Sherry" <swm@alcove.com.au>, pgsql-hackers@postgresql.org
Date: 2008-01-12T00:16:22Z
Lists: 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