Scott Marlowe wrote:
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.

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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to