Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id E880B64FCF3 for ; Wed, 27 Aug 2008 10:45:50 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 77954-01 for ; Wed, 27 Aug 2008 10:45:41 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from fort-mx02.den.api.local (unknown [66.35.32.228]) by postgresql.org (Postfix) with ESMTP id 3404664FCD4 for ; Wed, 27 Aug 2008 10:45:46 -0300 (ADT) Received: from 72-42-100-203.dhcp.leehcotccr01.WisperTel.net (jgc.vpn.api.local [192.168.11.52] (may be forged)) by fort-mx02.den.api.local (8.13.1/8.13.1) with ESMTP id m7RDjic1024369 for ; Wed, 27 Aug 2008 07:45:44 -0600 Message-ID: <48B55A8D.1050209@absolute-performance.com> Date: Wed, 27 Aug 2008 07:45:49 -0600 From: Jerry Champlin Organization: Absolute Performance Inc. User-Agent: Thunderbird 2.0.0.16 (Macintosh/20080707) MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Is there a way to SubPartition? Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.51 tagged_above=0 required=5 tests=RDNS_NONE=0.1, SUBJECT_FUZZY_TION=0.41 X-Spam-Level: X-Archive-Number: 200808/349 X-Sequence-Number: 31230 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