Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 61A3E9FB273 for ; Wed, 10 Jan 2007 16:31:10 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 84138-10 for ; Wed, 10 Jan 2007 16:30:52 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from myemma.com (db1.e2ma.net [66.179.147.163]) by postgresql.org (Postfix) with ESMTP id 397D49FB276 for ; Wed, 10 Jan 2007 16:30:52 -0400 (AST) Received: from localhost (localhost.localdomain [127.0.0.1]) by myemma.com (Postfix) with ESMTP id 6E22123CEB; Wed, 10 Jan 2007 14:30:51 -0600 (CST) Received: from myemma.com ([127.0.0.1]) by localhost (velma [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 01291-04; Wed, 10 Jan 2007 14:30:47 -0600 (CST) Received: from [10.0.23.43] (unknown [209.149.59.218]) by myemma.com (Postfix) with ESMTP id B674B23CD4; Wed, 10 Jan 2007 14:30:47 -0600 (CST) Message-ID: <45A54CF5.3090103@myemma.com> Date: Wed, 10 Jan 2007 14:30:45 -0600 From: Erik Jones User-Agent: Thunderbird 1.5.0.7 (Windows/20060909) MIME-Version: 1.0 To: "Jim C. Nasby" Cc: Mikael Carneholm , arnaulist@andromeiberica.com, pgsql-performance@postgresql.org Subject: Re: Partitioning References: <7F10D26ECFA1FB458B89C5B4B0D72C2B82CD0A@sesrv12.wirelesscar.com> <20070110202006.GU12217@nasby.net> In-Reply-To: <20070110202006.GU12217@nasby.net> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at myemma.com X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/147 X-Sequence-Number: 22748 On Fri, Jan 05, 2007 at 12:47:08PM +0100, Mikael Carneholm wrote: >> Take a look at the set of partitioning functions I wrote shortly after >> the 8.1 release: >> >> http://www.studenter.hb.se/~arch/files/part_functions.sql >> >> You could probably work something out using those functions (as-is, or >> as inspiration) together with pgAgent >> (http://www.pgadmin.org/docs/1.4/pgagent.html) >> >> /Mikael >> Those are some great functions. -- erik jones software development emma(r)