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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2001-06-06 14:45:46 Re: psql bug or feature?
Previous Message Tatsuo Ishii 2001-06-06 14:13:26 psql bug or feature?