Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 2DFB364FE0F for ; Tue, 2 Dec 2008 18:52:11 -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 07931-09 for ; Tue, 2 Dec 2008 18:52:08 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from rv-out-0506.google.com (rv-out-0506.google.com [209.85.198.237]) by mail.postgresql.org (Postfix) with ESMTP id 86EEE64FDB3 for ; Tue, 2 Dec 2008 18:52:08 -0400 (AST) Received: by rv-out-0506.google.com with SMTP id k40so3171228rvb.1 for ; Tue, 02 Dec 2008 14:52:07 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:cc:in-reply-to:mime-version:content-type :content-transfer-encoding:content-disposition:references; bh=fV9QqCqXktzblHfpgmteXkbZpEqIVv1gAqLKUdfHbQY=; b=e7WDYhbh4cRkWb7UKv5dpffe6GUJyanRg5nznjqimwf38YSBv23E21sS6FfQDZwt0K PuxyAK2AExRDalvInzr2Y/jw0lyaVSvGNUecFTKwpKgjXMOmtxOsnCzf1mJ0Pzp9U4BZ F/8Aj7bIh35G0+QHev45rmz8redJhk/CgXciE= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version :content-type:content-transfer-encoding:content-disposition :references; b=KuxDB0finFfERLS1IyiNBl8gci5+jhkK17LEG9dYn2G6GXZeF1520L7b3QwYJEXEdQ SNPRA3vFEWgOCjOPsPoK595wieZfJv1RSNpBb7b7WU3T2nBMo7908UvgkeK2dI6y4L5I KpTRekmWre1iau5r6tNb9G6q6v6YLWdr1irT4= Received: by 10.141.176.13 with SMTP id d13mr5971217rvp.231.1228258327139; Tue, 02 Dec 2008 14:52:07 -0800 (PST) Received: by 10.140.164.12 with HTTP; Tue, 2 Dec 2008 14:52:07 -0800 (PST) Message-ID: <603c8f070812021452m65ed412ckc416e14b8e8f3f77@mail.gmail.com> Date: Tue, 2 Dec 2008 17:52:07 -0500 From: "Robert Haas" To: "Emmanuel Cecchet" Subject: Re: Fwd: [PATCHES] Auto Partitioning Patch - WIP version 1 Cc: "Jaime Casanova" , "Gregory Stark" , "Alvaro Herrera" , "Nikhil Sontakke" , PostgreSQL-development In-Reply-To: <492EC647.4090706@frogthinker.org> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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> 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/97 X-Sequence-Number: 128726 On Thu, Nov 27, 2008 at 11:09 AM, Emmanuel Cecchet wrote: > I have been following that discussion very closely but it seems that we are > debating solutions without a good specification of the problem/requirements. > I would suggest that we collect all the partitioning requirements on a > dedicated Wiki page. There might not be a one size fits it all solution for > all requirements. We can also look at what other databases are proposing to > address these issues. > If we can prioritize features, that should also allow us to stage the > partitioning implementation. This might be a good idea. Want to take a crack at it? > I have a prototype insert trigger in C that directly move inserts in a > master table to the appropriate child table (directly moving the tuple). Let > me know if anyone is interested. Can't hurt to post it. ...Robert