Re: Bulk INSERT performance in 7.4.1 - Mailing list pgsql-performance

From Vivek Khera
Subject Re: Bulk INSERT performance in 7.4.1
Date
Msg-id x7r7w9smii.fsf@yertle.int.kciLink.com
Whole thread Raw
In response to Bulk INSERT performance in 7.4.1  (Florian Weimer <fw@deneb.enyo.de>)
Responses Re: Bulk INSERT performance in 7.4.1
Re: Bulk INSERT performance in 7.4.1
List pgsql-performance
>>>>> "FW" == Florian Weimer <fw@deneb.enyo.de> writes:

FW> After increasing the number of checkpoint segments and the shared-memory
FW> buffers, performance is back to the expected levels.  It might even be a
FW> bit faster.

If you've got the time, could you try also doing the full bulk insert
test with the checkpoint log files on another physical disk?  See if
that's any faster.

--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.                Khera Communications, Inc.
Internet: khera@kciLink.com       Rockville, MD  +1-301-869-4449 x806
AIM: vivekkhera Y!: vivek_khera   http://www.khera.org/~vivek/

pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Scaling further up
Next
From: Vivek Khera
Date:
Subject: Re: Bulk INSERT performance in 7.4.1