Horton

Re: Performance

Martijn van Oosterhout <kleptog@cupid.suninternet.com>

View thread View on postgr.es
From: Martijn van Oosterhout <kleptog@cupid.suninternet.com>
To: Ron Chmara <ron@opus1.com>
Cc: Thomas Weholt <Thomas@cintra.no>, pgsql-novice@postgresql.org
Date: 2000-06-02T14:55:24Z
Lists: pgsql-novice 
Ron Chmara wrote:
> On an extremely fast system, with Fsync off, this should take less than
> 30 seconds. On slower systems, or with fsync on, your performance will
> degrade greatly. I've seen 468 machines running at 2 inserts a second...

One thing I've noticed with loading lots of data using INSERTs is
that if you wrap the whole thing in a transaction, it goes heaps
faster (presumably because it only does one fsync, when the 
transaction is complete).
-- 
Martijn van Oosterhout <kleptog@cupid.suninternet.com>
http://cupid.suninternet.com/~kleptog/