Re: Performance over a LAN - Mailing list pgsql-performance

From Christopher Kings-Lynne
Subject Re: Performance over a LAN
Date
Msg-id 4100A9FE.2020905@familyhealth.com.au
Whole thread Raw
In response to Performance over a LAN  ("William Carney" <wcarney@sa.quiktrak.com.au>)
Responses Re: Performance over a LAN
List pgsql-performance
> But with the server running on one machine and the client running on
> another, the two machines being connected by a 100 Mb ethernet, with nothing
> else on the network, this test takes 17 minutes to run. I have tried
> changing the frequency of COMMIT operations, but with only a small effect.

Are you using separate INSERT statements?  Try using COPY instead, it's
much faster.

chris


pgsql-performance by date:

Previous
From: "William Carney"
Date:
Subject: Performance over a LAN
Next
From: Mark Aufflick
Date:
Subject: Re: Performance over a LAN