Skip site navigation (1) Skip section navigation (2)

Re: slow speeds after 2 million rows inserted

From: Nikola Milutinovic <alokin1(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: slow speeds after 2 million rows inserted
Date: 2006-12-29 19:50:12
Message-ID: 20061229195012.32633.qmail@web58701.mail.re1.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-general
> 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.

Nix.




__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

pgsql-general by date

Next:From: DennisDate: 2006-12-29 22:38:13
Subject: Re: Geographical redundancy
Previous:From: James NeffDate: 2006-12-29 19:36:44
Subject: Re: slow speeds after 2 million rows inserted

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group