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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux