Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1ToZFy-0007XT-LX for pgsql-performance@arkaria.postgresql.org; Fri, 28 Dec 2012 12:41:46 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1ToZFx-0000Ki-G7 for pgsql-performance@arkaria.postgresql.org; Fri, 28 Dec 2012 12:41:45 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1ToZFw-0000KZ-LX for pgsql-performance@postgresql.org; Fri, 28 Dec 2012 12:41:44 +0000 Received: from tamriel.snowman.net ([72.66.115.51]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1ToZFu-0001cF-E5 for pgsql-performance@postgresql.org; Fri, 28 Dec 2012 12:41:44 +0000 Received: by tamriel.snowman.net (Postfix, from userid 1000) id 6DCDE22D15; Fri, 28 Dec 2012 07:41:41 -0500 (EST) Date: Fri, 28 Dec 2012 07:41:41 -0500 From: Stephen Frost To: Vitalii Tymchyshyn Cc: Jeff Janes , 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: <20121228124141.GG16126@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="MrRUTeZlqqNo1jQ9" 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: 07:40:18 up 64 days, 11:04, 7 users, load average: 0.18, 0.12, 0.13 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 --MrRUTeZlqqNo1jQ9 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Vitalii, * Vitalii Tymchyshyn (tivv00@gmail.com) wrote: > There is switch-like sql case: [...] > It should work like C switch statement. It does and it doesn't. It behaves generally like a C switch statement, but is much more flexible and therefore can't be optimized like a C switch statement can be. Thanks, Stephen --MrRUTeZlqqNo1jQ9 Content-Type: application/pgp-signature; name="signature.asc" Content-Description: Digital signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.12 (GNU/Linux) iEYEARECAAYFAlDdk4UACgkQrzgMPqB3kihpyACeLA1mHTbOyKmg0qxI9uQl/VCK MJgAnAtiQgpYE+lMPSYw3ooBiydaTzVZ =5XX+ -----END PGP SIGNATURE----- --MrRUTeZlqqNo1jQ9--