Re: COPY and Volatile default expressions - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: COPY and Volatile default expressions
Date
Msg-id CA+U5nM+To5yv1m+pgT1TG-4yz1mKXNxR0CbLr8fTmrqGshVKdA@mail.gmail.com
Whole thread Raw
In response to Re: COPY and Volatile default expressions  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: COPY and Volatile default expressions
Re: COPY and Volatile default expressions
Re: COPY and Volatile default expressions
List pgsql-hackers
On 15 April 2013 16:55, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Simon Riggs <simon@2ndQuadrant.com> writes:
>> On 15 April 2013 16:24, David Fetter <david@fetter.org> wrote:
>>> Do you have numbers on this, or ways to gather same?  In other words,
>>> how do we know what resources (time, CPU cycles, disk seeks, etc.) are
>>> being consumed here?
>
>> The multi-insert optimisation for COPY is already there and works well
>> enough to have been committed.
>
> You seem to not have answered the question.  Exactly what sort of
> performance gain might be possible, bearing in mind that anything that
> invokes a trigger (for instance) is unlikely to be amazingly fast
> anyway?

Forgive me, I assumed the list would be familiar with the optimization
and so be excited by the need for this.

I will implement as a kluge, test and report the results.

Loading data into a table with a SERIAL or UUID column is the main use
case, so I'll measure that.

--Simon Riggs                   http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training & Services



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: COPY and Volatile default expressions
Next
From: David Fetter
Date:
Subject: Re: COPY and Volatile default expressions