| From: | Markus Schiltknecht <markus(at)bluegap(dot)ch> |
|---|---|
| To: | Hans-Juergen Schoenig <postgres(at)cybertec(dot)at> |
| Cc: | Hannu Krosing <hannu(at)tm(dot)ee>, Jeff Cohen <jcohen(at)greenplum(dot)com>, Warren Turkal <turkal(at)google(dot)com>, Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>, Gavin Sherry <swm(at)alcove(dot)com(dot)au>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Declarative partitioning grammar |
| Date: | 2008-01-15 14:23:58 |
| Message-ID: | 478CC1FE.7020005@bluegap.ch |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2008-01-15 14:54:51 | Re: SSL over Unix-domain sockets |
| Previous Message | Martijn van Oosterhout | 2008-01-15 14:23:53 | Re: SSL over Unix-domain sockets |