Re: COPY into table too slow with index: now an I/O - Mailing list pgsql-performance

From Michael Stone
Subject Re: COPY into table too slow with index: now an I/O
Date
Msg-id 20051202130419.GF7330@mathom.us
Whole thread Raw
In response to Re: COPY into table too slow with index: now an I/O  ("Luke Lonergan" <LLonergan@greenplum.com>)
List pgsql-performance
On Fri, Dec 02, 2005 at 12:15:57AM -0500, Luke Lonergan wrote:
>That's good to know - makes sense.  I suppose we might still thrash over
>a 1GB range in seeks if the BG writer starts running at full rate in the
>background, right?  Or is there some write combining in the BG writer?

That part your OS should be able to handle. Those writes aren't synced,
so the OS has plenty of opportunity to buffer & aggregate them.

Mike Stone

pgsql-performance by date:

Previous
From: Michael Stone
Date:
Subject: Re: 15,000 tables
Next
From: Alex Stapleton
Date:
Subject: Re: 15,000 tables