Martijn van Oosterhout wrote:
>>(Oracle has sort of rolled these ideas together with their partitioning)
>>
>>
>
>My guess is because segmenting without the planner cleverness is a bit
>useless.
>
Yes! you want the planner to be *aware* of any "segmenting", but there
are other was to reduce the "amount of table" that is scanned (e.g.
partial indexes and clustering), so the "Oracle solution" might not be
the only (or best) way to approach :
1 query plans for large tables
2 administration of large tables
cheers
Mark