pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Stephen Frost <sfrost@snowman.net>
To: Vitalii Tymchyshyn <tivv00@gmail.com>
Cc: Jeff Janes <jeff.janes@gmail.com>
Cc: Pavel Stehule <pavel.stehule@gmail.com>
Cc: Charles Gomes <charlesrg@outlook.com>
Cc: Ondrej Ivanič <ondrej.ivanic@gmail.com>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: Performance on Bulk Insert to Partitioned Table
Date: Fri, 28 Dec 2012 07:41:41 -0500
Message-ID: <20121228124141.GG16126@tamriel.snowman.net> (raw)
In-Reply-To: <CABWW-d0vqjkt3zcdG0FOvZPNoO3ah18Np5hni-8H1N-hq4koNw@mail.gmail.com>
References: <BLU002-W2777115565E1CBCF867857AB370@phx.gbl>
	<CAM6mieLLD+WBx_NXubUihbDbHzb46tjxYWNWg_VgjV9omwOVcw@mail.gmail.com>
	<BLU002-W73F8F8D02096BD549F2809AB370@phx.gbl>
	<CAMkU=1xbdrp-HsPQ5kJZDxDTWa8NnvLiYB9kXiCYN8X9WSGv8Q@mail.gmail.com>
	<BLU002-W20060321FFADD1AA11E2021AB3B0@phx.gbl>
	<CAMkU=1zJ7=DtRv8ikRH1Z8HcVwTKR+qw9yFF7z8mP__OL3D-9A@mail.gmail.com>
	<BLU002-W1773678852199862DEB5D7CAB380@phx.gbl>
	<CAMkU=1xZnkmeoTG9wrXshnSxWDCXGyO-tPRUYZ8YdgBptNcysA@mail.gmail.com>
	<20121227190019.GC16126@tamriel.snowman.net>
	<CABWW-d0vqjkt3zcdG0FOvZPNoO3ah18Np5hni-8H1N-hq4koNw@mail.gmail.com>
List-Unsubscribe:  <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>

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

Attachments:

  signature.asc (application/pgp-signature, 197B) download

view thread (48+ messages)  latest in thread

Message-ID: <20121228124141.GG16126@tamriel.snowman.net>
Permalink:  ../20121228124141.GG16126@tamriel.snowman.net/
Also on:    postgresql.org/message-id/20121228124141.GG16126@tamriel.snowman.net

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: sfrost@snowman.net, tivv00@gmail.com, jeff.janes@gmail.com, pavel.stehule@gmail.com, charlesrg@outlook.com, ondrej.ivanic@gmail.com
  Subject: Re: Performance on Bulk Insert to Partitioned Table
  In-Reply-To: <20121228124141.GG16126@tamriel.snowman.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox