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

Re: insertion of bytea

From: "Chris Mair" <list(at)1006(dot)org>
To: <mstone+postgres(at)mathom(dot)us>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: insertion of bytea
Date: 2005-10-27 13:40:04
Message-ID: 34757.193.206.186.101.1130420404.squirrel@www.endian.it (view raw or flat)
Thread:
Lists: pgsql-performance
> 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
> PQputCopyData).


Hi,

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 :(


Bye, Chris.


PS1: someone off-list suggested using oprofile, which I will do.

PS2: in case somebody is iterested, the test client is here:
     http://www.1006.org/tmp/20051027/

     pgclient-1.1.c is prepared inserts, 2.0 is binary copy.





In response to

Responses

pgsql-performance by date

Next:From: Jan WieckDate: 2005-10-27 13:41:26
Subject: Re: Perfomance of views
Previous:From: Merlin MoncureDate: 2005-10-27 12:59:51
Subject: Re: browsing table with 2 million records

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