Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Tlphr-0007Tf-AY for pgsql-performance@arkaria.postgresql.org; Thu, 20 Dec 2012 23:39:15 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1Tlphq-0007tK-4J for pgsql-performance@arkaria.postgresql.org; Thu, 20 Dec 2012 23:39:14 +0000 Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Tlpho-0007rs-E9 for pgsql-performance@postgresql.org; Thu, 20 Dec 2012 23:39:12 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Tlphn-0002fG-Aq for pgsql-performance@postgresql.org; Thu, 20 Dec 2012 23:39:11 +0000 Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.5/8.14.5) with ESMTP id qBKNd8Wo027307; Thu, 20 Dec 2012 18:39:08 -0500 (EST) From: Tom Lane To: Charles Gomes cc: =?iso-8859-2?B?T25kcmVqIEl2YW5p6A==?= , "pgsql-performance@postgresql.org" Subject: Re: Performance on Bulk Insert to Partitioned Table In-reply-to: References: , Comments: In-reply-to Charles Gomes message dated "Thu, 20 Dec 2012 17:59:18 -0500" Date: Thu, 20 Dec 2012 18:39:07 -0500 Message-ID: <27306.1356046747@sss.pgh.pa.us> X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org Charles Gomes writes: > Using rules would be totally bad as I'm partitioning daily and after one year having 365 lines of IF won't be fun to maintain. You should probably rethink that plan anyway. The existing support for partitioning is not meant to support hundreds of partitions; you're going to be bleeding performance in a lot of places if you insist on doing that. regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance