Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1ToafG-0000U8-O6 for pgsql-performance@arkaria.postgresql.org; Fri, 28 Dec 2012 14:11:58 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1ToafG-0008LY-6x for pgsql-performance@arkaria.postgresql.org; Fri, 28 Dec 2012 14:11:58 +0000 Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1ToafE-0008KB-Av for pgsql-performance@postgresql.org; Fri, 28 Dec 2012 14:11:56 +0000 Received: from tamriel.snowman.net ([72.66.115.51]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1ToafC-0007VB-5S for pgsql-performance@postgresql.org; Fri, 28 Dec 2012 14:11:55 +0000 Received: by tamriel.snowman.net (Postfix, from userid 1000) id 79F2222D15; Fri, 28 Dec 2012 09:11:53 -0500 (EST) Date: Fri, 28 Dec 2012 09:11:53 -0500 From: Stephen Frost To: Jeff Janes Cc: Vitalii Tymchyshyn , Pavel Stehule , Charles Gomes , Ondrej =?utf-8?Q?Ivani=C4=8D?= , "pgsql-performance@postgresql.org" Subject: Re: Performance on Bulk Insert to Partitioned Table Message-ID: <20121228141153.GJ16126@tamriel.snowman.net> References: <20121227190019.GC16126@tamriel.snowman.net> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="zYo4Elh1vtcYNvbq" Content-Disposition: inline In-Reply-To: X-Editor: Vim http://www.vim.org/ X-Info: http://www.snowman.net X-Operating-System: Linux/3.2.0-4-amd64 (x86_64) X-Uptime: 09:10:53 up 64 days, 12:34, 7 users, load average: 0.22, 0.19, 0.15 User-Agent: Mutt/1.5.21 (2010-09-15) 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 --zYo4Elh1vtcYNvbq Content-Type: text/plain; charset=us-ascii Content-Disposition: inline * Jeff Janes (jeff.janes@gmail.com) wrote: > I had thought that too, but the catch is that the target expressions do not > need to be constants when the function is created. Indeed, they can even > be volatile. Right, any optimization in this regard would only work in certain instances- eg: when the 'WHEN' components are all constants and the data type is something we can manage, etc, etc. Thanks, Stephen --zYo4Elh1vtcYNvbq Content-Type: application/pgp-signature; name="signature.asc" Content-Description: Digital signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.12 (GNU/Linux) iEYEARECAAYFAlDdqKkACgkQrzgMPqB3kigtqgCePTvddPvUPliSHMdI5oCPmL03 37kAn092OhPcaOwT31JaNu4gMzlpAhdl =1SMN -----END PGP SIGNATURE----- --zYo4Elh1vtcYNvbq--