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.
In response to
pgsql-interfaces by date
|Next:||From: Thomas Lockhart||Date: 1999-06-24 02:02:23|
|Subject: Re: [INTERFACES] Performance|
|Previous:||From: John Huttley||Date: 1999-06-24 01:09:04|
|Subject: Re: [INTERFACES] C tuples (For V7 please, hackers!)|