Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 9D74464FCD2 for ; Mon, 15 Dec 2008 14:48:30 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 27416-06 for ; Mon, 15 Dec 2008 14:48:27 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail-gx0-f12.google.com (mail-gx0-f12.google.com [209.85.217.12]) by mail.postgresql.org (Postfix) with ESMTP id 9F2FC64FCBE for ; Mon, 15 Dec 2008 14:48:27 -0400 (AST) Received: by gxk5 with SMTP id 5so2144930gxk.19 for ; Mon, 15 Dec 2008 10:48:26 -0800 (PST) Received: by 10.64.3.5 with SMTP id 5mr6397880qbc.75.1229366905971; Mon, 15 Dec 2008 10:48:25 -0800 (PST) Received: from oxford.xeocode.com.enterprisedb.com (76-10-183-168.dsl.teksavvy.com [76.10.183.168]) by mx.google.com with ESMTPS id s12sm117398qbs.10.2008.12.15.10.46.44 (version=TLSv1/SSLv3 cipher=RC4-MD5); Mon, 15 Dec 2008 10:46:45 -0800 (PST) To: Josh Berkus Cc: Emmanuel Cecchet , Nikhil Sontakke , PostgreSQL-development Subject: Re: Fwd: [PATCHES] Auto Partitioning Patch - WIP version 1 In-Reply-To: <49469894.4070406@agliodbs.com> (Josh Berkus's message of "Mon\, 15 Dec 2008 09\:49\:08 -0800") User-Agent: Gnus/5.11 (Gnus v5.11) Emacs/22.1 (gnu/linux) X-Draft-From: ("nnimap+imap.gmail.com:HACKERS" 51300) References: <3073cc9b0810220744y987173avd560a33fcb58ede5@mail.gmail.com> <603c8f070811262009v459d0701w151c16533d4ab947@mail.gmail.com> <20081127120402.GC4586@alvh.no-ip.org> <603c8f070811270507i36e18e0bu5d461a4f957e24d3@mail.gmail.com> <871vwxpa7b.fsf@oxford.xeocode.com> <603c8f070811270641u55bbf340p3383dcc6a6f1f6e8@mail.gmail.com> <3073cc9b0811270710p3a2e5ae9s10f66b529550c03e@mail.gmail.com> <3073cc9b0811270712l6384c28awac4f0318c704df99@mail.gmail.com> <492EC647.4090706@frogthinker.org> <603c8f070812021452m65ed412ckc416e14b8e8f3f77@mail.gmail.com> <493F1279.8010804@frogthinker.org> <49469894.4070406@agliodbs.com> From: Gregory Stark Organization: EnterpriseDB Date: Mon, 15 Dec 2008 18:46:43 +0000 Message-ID: <87abaxp97w.fsf@oxford.xeocode.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.41 tagged_above=0 required=5 tests=SUBJECT_FUZZY_TION=0.41 X-Spam-Level: X-Archive-Number: 200812/1185 X-Sequence-Number: 129814 Josh Berkus writes: > Hackers, > > We don't yet seem to have a clear specification for this feature, and the Other > Open Source DB has shown us how problematic it is to get auto-partitioning > wrong. > > Should we defer auto-partitioning to 8.5? If we're serious about having a "next generation" partitioning with a concept of partition keys then it seems to me to make more sense to do that first and then add on a feature like this. This is still very useful. I haven't looked at the actual patch, does it require core changes or can it be stashed in a pgfoundry or contrib module? -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's 24x7 Postgres support!