On Mon, Apr 15, 2013 at 05:04:16PM +0100, Simon Riggs wrote: > On 15 April 2013 16:55, Tom Lane <t...@sss.pgh.pa.us> wrote: > > Simon Riggs <si...@2ndquadrant.com> writes: > >> On 15 April 2013 16:24, David Fetter <da...@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.
The former is common enough a use case to optimize specifically, should the numbers come out right. Do you suppose that an in-core UUID generator would help the latter make more sense as a part of the same use case? Cheers, David. -- David Fetter <da...@fetter.org> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers