Re: Low throughput of binary inserts from windows to linux - Mailing list pgsql-performance

From Axel Waggershauser
Subject Re: Low throughput of binary inserts from windows to linux
Date
Msg-id 5e66c6e90612110716h59243be7tfd5a441cfb2c0c47@mail.gmail.com
Whole thread Raw
In response to Re: Low throughput of binary inserts from windows to linux  ("Thomas H." <me@alternize.com>)
List pgsql-performance
On 12/11/06, Thomas H. <me@alternize.com> wrote:
> > I'm out of ideas here, maybe someone could try to reproduce this
> > behavior or could point me to the thread containing relevant
> > information (sorry, maybe I'm just too dumb :-/)
>
> please specify how you're transfering the data from windows -> linux. are
> you using odbc? if yes, what driver? are you using FDQN server names or a
> plain ip adress? etc etc.

You may take a look at my first mail (starting this thread), there you
find a my_lo.c attached, containing a the complete code. I use libpq.
The connection is established like this:

     conn = PQsetdbLogin(argv[1], "5432", NULL, NULL, argv[2],
argv[3], argv[4]);

I called the test program with the plain ip-address of the server machine.

Axel

pgsql-performance by date:

Previous
From: "Thomas H."
Date:
Subject: Re: Low throughput of binary inserts from windows to linux
Next
From: "Rajesh Kumar Mallah"
Date:
Subject: Re: Postgresql - Threshold value.