Received: from sunpine.krs.ru (SunPine.krs.ru [195.161.16.37])
	by hub.org (8.9.3/8.9.3) with ESMTP id VAA05527
	for <pgsql-interfaces@postgreSQL.org>;
	Wed, 23 Jun 1999 21:21:22 -0400 (EDT) (envelope-from vadim@krs.ru)
Received: from krs.ru (dune.krs.ru [195.161.16.38])
	by sunpine.krs.ru (8.8.8/8.8.8) with ESMTP id JAA12159;
	Thu, 24 Jun 1999 09:21:15 +0800 (KRSS)
Sender: root@sunpine.krs.ru
Message-ID: <3771880B.5109FA39@krs.ru>
Date: Thu, 24 Jun 1999 09:21:15 +0800
From: Vadim Mikheev <vadim@krs.ru>
Organization: OJSC Rostelecom (Krasnoyarsk)
X-Mailer: Mozilla 4.5 [en] (X11; I; FreeBSD 3.0-RELEASE i386)
X-Accept-Language: ru, en
MIME-Version: 1.0
To: Steven Bradley <sbradley@llnl.gov>
CC: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] Performance
References: <3.0.5.32.19990623150509.0092e990@poptop.llnl.gov>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

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