Horton

Re: Feature suggestions (long)

Mark Kirkwood <markir@paradise.net.nz>

View thread
From: Mark Kirkwood <markir@paradise.net.nz>
To: Martijn van Oosterhout <kleptog@svana.org>
Cc: Matthew Kirkwood <matthew@hairy.beasts.org>, Alvaro Herrera <alvherre@dcc.uchile.cl>, Tom Lane <tgl@sss.pgh.pa.us>, pgsql-hackers@postgresql.org
Date: 2003-05-19T07:55:07Z
Lists: pgsql-hackers 

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