Re: COPY into table too slow with index: now an I/O

From: Michael Stone <mstone+postgres(at)mathom(dot)us>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: COPY into table too slow with index: now an I/O
Date: 2005-12-02 13:04:19
Message-ID: 20051202130419.GF7330@mathom.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Teracat 2005-12-02 13:05:26 Network permormance under windows
Previous Message Michael Stone 2005-12-02 13:02:16 Re: 15,000 tables