Re: Feature suggestions (long)

Martijn van Oosterhout <kleptog@svana.org> writes:
> I'm going suggest a feature like what Oracle calls "partitions" and later on
> something with indexes. The idea is to generate some discussion to see if
> they are worthy of being added to the TODO list.

Why bother?  Make partial indexes corresponding to what you are calling
the partitions of the table, and (I claim) you can get every possible
benefit of a partitioning scheme.  Plus more, because there's nothing
constraining the partial indexes to be nonoverlapping, so you can get
efficient plans for sets of queries that no partitioning scheme would
win for.
        regards, tom lane