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

Re: slow speeds after 2 million rows inserted

From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
To: Nikola Milutinovic <alokin1(at)yahoo(dot)com>, Chad Wagner <chad(dot)wagner(at)gmail(dot)com>
Cc: PostgreSQL general <pgsql-general(at)postgresql(dot)org>
Subject: Re: slow speeds after 2 million rows inserted
Date: 2006-12-31 17:00:50
Message-ID: 695013.37136.qm@web31811.mail.mud.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-general
> 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
> speedup.
> 
> > 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
test.
http://archives.postgresql.org/pgsql-general/2006-10/msg00662.php

Regards,

Richard Broersma Jr.

In response to

pgsql-general by date

Next:From: Chad WagnerDate: 2006-12-31 17:08:12
Subject: Re: slow speeds after 2 million rows inserted
Previous:From: Martijn van OosterhoutDate: 2006-12-31 16:54:55
Subject: Re: Generic timestamp function for updates where field

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