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: Pine.BSF.4.33.0106061141540.38494-100000@mobile.hub.org (view raw or flat)
Thread:
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
configuration?

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


Responses

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-2014 The PostgreSQL Global Development Group