Max inserts / sec ... on any platform? 
Author Message
 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


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate

message can get through to the mailing list cleanly



Sun, 23 Nov 2003 22:53:02 GMT
 Max inserts / sec ... on any platform?

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

--

 ??-?

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate

message can get through to the mailing list cleanly



Mon, 24 Nov 2003 00:56:51 GMT
 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?

Quote:

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

> message can get through to the mailing list cleanly

Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster



Mon, 24 Nov 2003 03:28:06 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Max insert instruction pro sec

2. Max insert instruction pro sec

3. MSSQL Limits (Trans/sec & Max data output)

4. a question about logins/sec and logouts/sec

5. Pages/sec, Page Reads/sec

6. 5500 inserts/sec possible on 7.3.4?

7. Max number of files in a database (Unix platform)

8. How to insert date/time data platform independently?

9. Imitating one machine platform on another platform

10. REPLACE Platform->VO WITH Platform->Delphi

11. Inserting and incrementing with MAX aggregate


 
Powered by phpBB® Forum Software