Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id AFC97632EA4 for ; Thu, 4 Feb 2010 17:59:47 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 35510-07 for ; Thu, 4 Feb 2010 21:59:37 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.kickstone.com (smtp.kickstone.com [87.194.183.70]) by mail.postgresql.org (Postfix) with ESMTP id 3C3BA632C30 for ; Thu, 4 Feb 2010 17:59:37 -0400 (AST) Received: from [80.225.58.208] (port=58035 helo=[192.168.6.10]) by mail.kickstone.com with esmtpa (Exim 4.69) (envelope-from ) id 1Nd9ja-0007WW-Jo for pgsql-sql@postgresql.org; Thu, 04 Feb 2010 21:59:34 +0000 Message-ID: <4B6B4349.9060103@kickstone.com> Date: Thu, 04 Feb 2010 21:59:37 +0000 From: John Lister User-Agent: Thunderbird 2.0.0.23 (Windows/20090812) MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Partitioning improvements query References: <4B636022.90804@kickstone.com> <3AD82906BF1A43CB940573A88A42C2B3@squarepi.com> <4B6B4012.7040802@kickstone.co.uk> In-Reply-To: <4B6B4012.7040802@kickstone.co.uk> 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.029 tagged_above=-10 required=5 tests=BAYES_40=-0.185, SUBJECT_FUZZY_TION=0.156 X-Spam-Level: X-Archive-Number: 201002/30 X-Sequence-Number: 33629 Hi all, I was just wondering if any progress has been made on improving partitioning, particuarly performance wise. I've found a few documents on the web, for example: http://wiki.postgresql.org/wiki/Table_partitioning and http://wiki.postgresql.org/wiki/Image:Partitioning_Requirements.pdf, http://wiki.postgresql.org/wiki/PgCon_2008_Developer_Meeting#Partitioning_Roadmap which mention improvements to partitioning, but I can't find any info if these have been acted on. Just curious as things like pushing limits down to the sub queries would be a great feature, etc Cheers John