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

help / color / mirror / Atom feed
From: Stephen Frost <sfrost@snowman.net>
To: Jeff Janes <jeff.janes@gmail.com>
Cc: Vitalii Tymchyshyn <tivv00@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 09:11:53 -0500
Message-ID: <20121228141153.GJ16126@tamriel.snowman.net> (raw)
In-Reply-To: <CAMkU=1xcdjdFWRSZyaXyo2h8eHYz7DJRTpqeL1shMO5M858MMw@mail.gmail.com>
References: <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>
	<CAMkU=1xcdjdFWRSZyaXyo2h8eHYz7DJRTpqeL1shMO5M858MMw@mail.gmail.com>
List-Unsubscribe:  <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>

* 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

Attachments:

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

view thread (48+ messages)  latest in thread

Message-ID: <20121228141153.GJ16126@tamriel.snowman.net>
Permalink:  ../20121228141153.GJ16126@tamriel.snowman.net/
Also on:    postgresql.org/message-id/20121228141153.GJ16126@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, jeff.janes@gmail.com, tivv00@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: <20121228141153.GJ16126@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