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


--

 

In response to

• Max inserts / sec ... on any platform? at 2001-06-06 14:44:29 from The Hermit Hacker

Responses

• Re: Max inserts / sec ... on any platform? at 2001-06-06 18:45:40 from The Hermit Hacker

pgsql-hackers by date

Next:	From: Peter Eisentraut	Date: 2001-06-06 15:47:25
	Subject: Re: Can the backend return more than one error message per PQexec?
Previous:	From: Martín Marqués	Date: 2001-06-06 15:39:42
	Subject: something smells bad