Re: Performance on Bulk Insert to Partitioned Table - Mailing list pgsql-performance

From Stephen Frost
Subject Re: Performance on Bulk Insert to Partitioned Table
Date
Msg-id 20121228141153.GJ16126@tamriel.snowman.net
Whole thread Raw
In response to Re: Performance on Bulk Insert to Partitioned Table  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-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

Attachment

pgsql-performance by date:

Previous
From: Stephen Frost
Date:
Subject: Re: Performance on Bulk Insert to Partitioned Table
Next
From: Pavel Stehule
Date:
Subject: Re: Performance on Bulk Insert to Partitioned Table