| From: | Jerry Champlin <jchamplin(at)absolute-performance(dot)com> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Is there a way to SubPartition? |
| Date: | 2008-08-27 13:45:49 |
| Message-ID: | 48B55A8D.1050209@absolute-performance.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Is there a way to use multi-level inheritance to achieve sub
partitioning that the query optimizer will recognize? With our current
application design, we would need a partition for every other day for
18 months which will not perform well. The reason we need so many
partitions is that we can't afford to vacuum the active partition (750MM
inserts + updates per day is the performance requirement for 12 months
out). After it's a day old, there are no longer any updates or inserts
and we can vacuum it at that point. If multi-level partitioning
worked, we could solve this problem without changing our code. Ideas?
-Jerry
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2008-08-27 14:01:50 | Re: Is there a way to SubPartition? |
| Previous Message | DANIEL CRISTIAN CRUZ | 2008-08-27 13:24:51 | Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception |