Is there a way to SubPartition?

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: Raw Message | Whole Thread | 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

Responses

Browse pgsql-performance by date

  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