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

Max inserts / sec ... on any platform?

From: The Hermit Hacker <scrappy(at)hub(dot)org>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: Max inserts / sec ... on any platform?
Date: 2001-06-06 14:44:29
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
Morning all ...

	Build a file with 100k INSERT statements in it, and run psql -f on
that file ... no BEGIN/END in the file, just straight INSERTs ... what is
the max throughput ppl can see?

	I'm seeing reports of it maxing out on an AIX around 450, and on
an HP around 380 ... anyone seeing higher?  and what sort of

Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy
Systems Administrator @
primary: scrappy(at)hub(dot)org           secondary: scrappy(at){freebsd|postgresql}.org


pgsql-hackers by date

Next:From: Peter EisentrautDate: 2001-06-06 14:45:46
Subject: Re: psql bug or feature?
Previous:From: Tatsuo IshiiDate: 2001-06-06 14:13:26
Subject: psql bug or feature?

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