Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id A43171337B93 for ; Tue, 8 Mar 2011 11:55:25 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 63279-02 for ; Tue, 8 Mar 2011 15:55:17 +0000 (UTC) X-Greylist: delayed 00:10:04.106534 by SQLgrey-1.7.6 Received: from smtp1.infomaniak.ch (smtp1.infomaniak.ch [84.16.68.89]) by mail.postgresql.org (Postfix) with ESMTP id D850E133798E for ; Tue, 8 Mar 2011 11:55:14 -0400 (AST) Received: from [192.168.25.106] (reverse.completel.net [92.103.1.80] (may be forged)) (authenticated bits=0) by smtp1.infomaniak.ch (8.14.2/8.14.2) with ESMTP id p28Fj8mg031229 (version=TLSv1/SSLv3 cipher=AES256-SHA bits=256 verify=NO) for ; Tue, 8 Mar 2011 16:45:09 +0100 Message-ID: <4D764F04.7020400@intesens.com> Date: Tue, 08 Mar 2011 16:45:08 +0100 From: Samba GUEYE User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; fr; rv:1.9.2.15) Gecko/20110303 Thunderbird/3.1.9 MIME-Version: 1.0 To: Postgre Performance Subject: Table partitioning problem 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=-1.61 tagged_above=-10 required=5 tests=BAYES_00=-1.9, MAY_BE_FORGED=0.29 X-Spam-Level: X-Archive-Number: 201103/89 X-Sequence-Number: 42768 Hello, I have a problem with table partitioning because i have a foreign key applied on the partionned table and it throw a constraint violation error during inserts. I saw on the manual (http://www.postgresql.org/docs/8.4/interactive/ddl-inherit.html caveats section) that it's a limitation due to postgrsql table inheritance select queries performance are really bad without partitionning and i'm looking for a workaround to this foreign key problem or another solution for improve performance for larges tables. Thanks in advance for your responses