| From: | Mark Kirkwood <markir(at)paradise(dot)net(dot)nz> |
|---|---|
| To: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
| Cc: | Matthew Kirkwood <matthew(at)hairy(dot)beasts(dot)org>, Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Feature suggestions (long) |
| Date: | 2003-05-19 07:55:07 |
| Message-ID: | 3EC88DDB.9000502@paradise.net.nz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Zeugswetter Andreas SB SD | 2003-05-19 08:46:04 | Re: Feature suggestions (long) |
| Previous Message | A.Bhuvaneswaran | 2003-05-19 07:18:24 | Re: Heads up: 7.3.3 this Wednesday |