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

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

From: The Hermit Hacker <scrappy(at)hub(dot)org>
To: KuroiNeko <evpopkov(at)carrier(dot)kiev(dot)ua>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Max inserts / sec ... on any platform?
Date: 2001-06-06 18:45:40
Message-ID: Pine.BSF.4.33.0106061545000.38494-100000@mobile.hub.org (view raw or flat)
Thread:
Lists: pgsql-hackers

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(at)postgresql(dot)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(at)hub(dot)org           secondary: scrappy(at){freebsd|postgresql}.org


In response to

pgsql-hackers by date

Next:From: The Hermit HackerDate: 2001-06-06 18:46:30
Subject: Re: Dual-CPU slower then Single under HP?
Previous:From: Feng TianDate: 2001-06-06 18:17:16
Subject: Adding some new operators

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