
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


Wed, 6 Jun 2001 11:44:29 -0300 (ADT)
The Hermit Hacker <scrappy@hub.org>
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.


--

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


Wed, 06 Jun 2001 15:45:58 +0000
KuroiNeko <evpopkov@carrier.kiev.ua>
Re: Max inserts / sec ... on any platform?


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


Wed, 6 Jun 2001 15:45:40 -0300 (ADT)
The Hermit Hacker <scrappy@hub.org>
Re: Max inserts / sec ... on any platform?