From: Vadim Mikheev <vadim@krs.ru>
To: Steven Bradley <sbradley@llnl.gov>
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] Performance
Date: Thu, 24 Jun 1999 09:21:15 +0800
Message-ID: <3771880B.5109FA39@krs.ru> (raw)
References: <3.0.5.32.19990623150509.0092e990@poptop.llnl.gov>
Steven Bradley wrote:
>
> I have simplified the problem down to a single (non-indexed) table with
> about a half-dozen columns (int4, timestamp, varchar, etc.) I wrote a
> quick and dirty C program which uses the libpq interface to INSERT records
> into the table in real-time. The best performance I could achieve was on
> the order of 15 inserts per second. What I need is something much closer
> to 100 inserts per second.
Put INSERTs inside BEGIN/END to execute them in single transaction.
Vadim
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: vadim@krs.ru, sbradley@llnl.gov
Subject: Re: [INTERFACES] Performance
In-Reply-To: <3771880B.5109FA39@krs.ru>
* 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