Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Fri, 29 Dec 2006 11:50:12 -0800 (PST)
> 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
- Prev by Date: Re: slow speeds after 2 million rows inserted
- Next by Date: Re: out of memory woes
- Previous by thread: Re: slow speeds after 2 million rows inserted
- Next by thread: Re: slow speeds after 2 million rows inserted
- Indexes: