Re: [BUGS] BUG #2567: High IOWAIT - Mailing list pgsql-performance

From Markus Schaber
Subject Re: [BUGS] BUG #2567: High IOWAIT
Date
Msg-id 44DC4463.5@logix-tt.com
Whole thread Raw
In response to Re: [BUGS] BUG #2567: High IOWAIT  ("Jim Nasby" <jnasby@pervasive.com>)
List pgsql-performance
Hi, Jim,

Jim Nasby wrote:

> Your biggest win would be to batch those inserts together into
> transactions, if possible.

Using COPY instead of INSERT might even give better wins, and AFAIK some
client libs use COPY internally (e. G. tablewriter from libpqxx).

> If not, the commit_delay settings might help you out.

As far as I understand, this will only help for concurrent inserts by
different clients, dealing throughput for latency. Please correct me if
I'm wrong.

HTH,
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org

pgsql-performance by date:

Previous
From: "Carl Youngblood"
Date:
Subject: Re: Beginner optimization questions, esp. regarding Tsearch2
Next
From: Markus Schaber
Date:
Subject: Re: Migrating data from DB2 to SQL Server