> The fastest way will be copy.
> The second fastest will be multi value inserts in batches.. eg.;
> INSERT INTO data_archive values () () () (I don't knwo what the max is)
> but commit every 1000 inserts or so.
Is this some empirical value? Can someone give heuristics as to how to calculate the optimal number of transactions after which to commit? Or at least guidelines.
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
pgsql-general by date
|Next:||From: Dennis||Date: 2006-12-29 22:38:13|
|Subject: Re: Geographical redundancy|
|Previous:||From: James Neff||Date: 2006-12-29 19:36:44|
|Subject: Re: slow speeds after 2 million rows inserted|