From: Maarten Boekhold <boekhold@tibco.com>
To: Tom Ivar Helbekkmo <tih@Norway.EU.net>
Cc: Steven Bradley <sbradley@llnl.gov>
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] Performance
Date: Thu, 24 Jun 1999 09:36:51 +0200
Message-ID: <3771E013.E64518BA@tibco.com> (raw)
References: <3.0.5.32.19990623150509.0092e990@poptop.llnl.gov>
<86g13i86cz.fsf@athene.i.eunet.no>
> second. I then wrapped the whole series of inserts in a BEGIN/END
> block. This increased the speed to about 1000 inserts per second.
> Yup. A thousand. That's 40 times the speed. Pretty cool. :-)
How did you measure this? Did you do (pseudo code):
start_time = now
SQL BEGIN
SQL INSERT's..
...
SQL END
end_time = now
print number_inserts / (end_time - start_time)
or
SQL BEGIN
start_time = now
SQL INSERT's
....
end_time = now
SQL END
print number_inserts / (end_time - start_time)
This makes a difference, since a lot of processing is done on commit time. The second
variant might thus be misleading.
Maarten
--
Maarten Boekhold, boekhold@tibco.com
TIBCO Finance Technology Inc.
The Atrium
Strawinskylaan 3051
1077 ZX Amsterdam, The Netherlands
tel: +31 20 3012158, fax: +31 20 3012358
http://www.tibco.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: boekhold@tibco.com, tih@Norway.EU.net, sbradley@llnl.gov
Subject: Re: [INTERFACES] Performance
In-Reply-To: <3771E013.E64518BA@tibco.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox