Re: Bulk INSERT performance in 7.4.1

From: Vivek Khera <khera(at)kcilink(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Bulk INSERT performance in 7.4.1
Date: 2004-03-03 20:28:53
Message-ID: x7r7w9smii.fsf@yertle.int.kciLink.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

>>>>> "FW" == Florian Weimer <fw(at)deneb(dot)enyo(dot)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(at)kciLink(dot)com Rockville, MD +1-301-869-4449 x806
AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Greg Spiegelberg 2004-03-03 21:37:48 Re: Bulk INSERT performance in 7.4.1
Previous Message John Siracusa 2004-03-03 19:56:06 Feature request: smarter use of conditional indexes