> On Tue, Oct 25, 2005 at 03:44:36PM +0200, Chris Mair wrote:
>>Is there a better, faster way to do these inserts?
> COPY is generally the fastest way to do bulk inserts (see
I've rewritten the testclient now to use COPY, but I'm getting
the exact same results as when doing bundled, prepared inserts.
I'm CPU-bound with an I/O well below what my disks could do :(
PS1: someone off-list suggested using oprofile, which I will do.
PS2: in case somebody is iterested, the test client is here:
pgclient-1.1.c is prepared inserts, 2.0 is binary copy.
In response to
pgsql-performance by date
|Next:||From: Jan Wieck||Date: 2005-10-27 13:41:26|
|Subject: Re: Perfomance of views|
|Previous:||From: Merlin Moncure||Date: 2005-10-27 12:59:51|
|Subject: Re: browsing table with 2 million records|