Re: 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.


--
������������������