From: Jerry Champlin <jchamplin@absolute-performance.com>
To: pgsql-performance@postgresql.org
Subject: Is there a way to SubPartition?
Date: Wed, 27 Aug 2008 07:45:49 -0600
Message-ID: <48B55A8D.1050209@absolute-performance.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: jchamplin@absolute-performance.com
Subject: Re: Is there a way to SubPartition?
In-Reply-To: <48B55A8D.1050209@absolute-performance.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox