Thread: Max inserts / sec ... on any platform?
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@hub.org secondary: scrappy@{freebsd|postgresql}.org
> 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