> It was really some time ago, since I have experimented with this. My las experiment was on PG
> 7.2 or 7.3. I was inserting cca 800,000 rows. Inserting without transactions took 25 hrs.
> Inserting with 10,000 rows per transaction took about 2.5 hrs. So, the speedup was 10x. I have
> not experimented with the transaction batch size, but I suspect that 1,000 would not show much
> > 2. Vacuuming also makes no difference for a heavy insert-only table, only slows it down.
> Makes sense. Since my application was dumping all records each month and inserting new ones,
> vacuum was really needed, but no speedup.
> > 3. Table size plays no real factor.
Maybe this link my be useful, it contains additional links to various postgresql preformance
Richard Broersma Jr.
In response to
pgsql-general by date
|Next:||From: Chad Wagner||Date: 2006-12-31 17:08:12|
|Subject: Re: slow speeds after 2 million rows inserted|
|Previous:||From: Martijn van Oosterhout||Date: 2006-12-31 16:54:55|
|Subject: Re: Generic timestamp function for updates where field|