| From: | Markus Schaber <schabi(at)logix-tt(dot)com> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Cc: | Kumarselvan S <kumar(at)nexge(dot)com> |
| Subject: | Re: [BUGS] BUG #2567: High IOWAIT |
| Date: | 2006-08-11 08:48:35 |
| Message-ID: | 44DC4463.5@logix-tt.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Markus Schaber | 2006-08-11 08:53:58 | Re: Migrating data from DB2 to SQL Server |
| Previous Message | Carl Youngblood | 2006-08-11 04:18:53 | Re: Beginner optimization questions, esp. regarding Tsearch2 |