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: (view raw, whole thread or download thread mbox)
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).


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:

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

In response to


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-2017 The PostgreSQL Global Development Group