Max inserts / sec ... on any platform?

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?

Hmmmm.... Depends. Inserting up to 5,000 of Apache log records takes no
longer than a couple of wallclock minutes on Pentium-133 with 48 MB RAM and
no-cache Fujitsu IDE HDD (no DMA). (OK, OK, it's a home server, under my
desk :) No psql -f, though, using a home brewn dumb script runner. And yes,
no fsync and 10 inserts per transaction. Relation is currently 350,000+
long.
Not sure whether it makes interest. Care to send your file for me to try
it out? [bg]zip is OK.

--

������������������������������������

Okay, based on 5k records and a "couple of wallclock minutes" being equal
to ~120sec, you are getting 41 inserts/sec?

On Wed, 6 Jun 2001, KuroiNeko wrote:

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?

Hmmmm.... Depends. Inserting up to 5,000 of Apache log records takes no
longer than a couple of wallclock minutes on Pentium-133 with 48 MB RAM and
no-cache Fujitsu IDE HDD (no DMA). (OK, OK, it's a home server, under my
desk :) No psql -f, though, using a home brewn dumb script runner. And yes,
no fsync and 10 inserts per transaction. Relation is currently 350,000+
long.
Not sure whether it makes interest. Care to send your file for me to try
it out? [bg]zip is OK.

--

LD$/G-$OAM$rJa$i$L

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

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