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

Поиск
Список
Период
Сортировка
От Michael Stone
Тема Re: COPY into table too slow with index: now an I/O
Дата
Msg-id 20051202130419.GF7330@mathom.us
обсуждение исходный текст
Ответ на Re: COPY into table too slow with index: now an I/O  ("Luke Lonergan" <LLonergan@greenplum.com>)
Список 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 по дате отправления:

Предыдущее
От: Michael Stone
Дата:
Сообщение: Re: 15,000 tables
Следующее
От: Alex Stapleton
Дата:
Сообщение: Re: 15,000 tables