Scott Marlowe wrote: 2012/3/12 François Beausoleil <francois@xxxxxxxxxxx>: > Hi all, > > When using COPY FROM STDIN to stream thousands of rows (20k and more hourly), what happens with indices? Are they updated only once after the operation, or are they updated once per row? Note that I'm not replacing the table's data: I'm appending to what's already there. I suspect batching writes will be faster than writing each individual row using an INSERT statement. Copy is faster, but if a single row fails (dup key etc) the whole copy fails. Hi Scott, my impression: it would be even faster to drop the indices, do the bulk copy, and rebuild the indices after the fact. Regards Wolfgang Hamann -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
