X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 207FE9DC859 for ; Tue, 13 Dec 2005 19:17:06 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 60388-07 for ; Tue, 13 Dec 2005 19:17:08 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from smtp.nildram.co.uk (smtp.nildram.co.uk [195.112.4.54]) by postgresql.org (Postfix) with ESMTP id CF50C9DC84B for ; Tue, 13 Dec 2005 19:17:03 -0400 (AST) Received: from [192.168.0.4] (unknown [84.12.28.16]) by smtp.nildram.co.uk (Postfix) with ESMTP id F16B926A821; Tue, 13 Dec 2005 23:17:01 +0000 (GMT) Subject: Re: Table Partitions / Partial Indexes From: Simon Riggs To: Mike C Cc: pgsql-performance@postgresql.org In-Reply-To: References: Content-Type: text/plain Date: Tue, 13 Dec 2005 23:17:05 +0000 Message-Id: <1134515825.27873.122.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.2.3 (2.2.3-2.fc4) Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200512/320 X-Sequence-Number: 16141 On Mon, 2005-12-12 at 15:07 +1300, Mike C wrote: > Partitioning on date range doesn't make much sense for this setup, > where a typical 1-month query spans both tables (as the billing month > for the customer might start midway through a calendar month). Maybe not for queries, but if you use a date range then you never need to run a DELETE and never need to VACUUM. You could split the data into two-day chunks. > Am I using a horrid method for partitioning the data? (% 10) No, but what benefit do you think it provides. I'm not sure I see... > Should there be that big of an improvement for multiple tables given > that all the data is still stored on the same filesystem? You could store partitions in separate tablespaces/filesystems. Best Regards, Simon Riggs