Re: Declarative partitioning grammar

Hi,

Hans-Juergen Schoenig wrote:
>> What do you need so many partitions for?
> 
> having so many tables is not funny but it can be the only reasonable choice.

Well, what do you do with all those partitions? Most of them will end up 
on the same storage subsystem. So, if you don't partition to spread your 
data across storage with different characteristics, why do you need 
partitioning at all? Isn't an index better in most cases?

Or are you using it as a form of CLUSTERing? Where you expect to reduce 
time for sequential scans over a range? Simon's Segment Exclusion 
proposal looks like a much better fit to that purpose, IMO. It would 
prevent you from having to handle all those partitions manually.

Regards

Markus