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. -- Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
