2012/3/12 François Beausoleil <franc...@teksol.info>: > 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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
