Skip site navigation (1) Skip section navigation (2)

Re: Max inserts / sec ... on any platform?

From: KuroiNeko <evpopkov(at)carrier(dot)kiev(dot)ua>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Max inserts / sec ... on any platform?
Date: 2001-06-06 15:45:58
Message-ID: 3B1E5036.nailCH7Z1QL0@ed.ed (view raw or flat)
Thread:
Lists: pgsql-hackers
>  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

Responses

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group