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
