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

Re: [INTERFACES] Performance

From: Vadim Mikheev <vadim(at)krs(dot)ru>
To: Steven Bradley <sbradley(at)llnl(dot)gov>
Cc: pgsql-interfaces(at)postgreSQL(dot)org
Subject: Re: [INTERFACES] Performance
Date: 1999-06-24 01:21:15
Message-ID: 3771880B.5109FA39@krs.ru (view raw or flat)
Thread:
Lists: pgsql-interfaces
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

In response to

  • Performance at 1999-06-23 22:05:09 from Steven Bradley

pgsql-interfaces by date

Next:From: Thomas LockhartDate: 1999-06-24 02:02:23
Subject: Re: [INTERFACES] Performance
Previous:From: John HuttleyDate: 1999-06-24 01:09:04
Subject: Re: [INTERFACES] C tuples (For V7 please, hackers!)

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