Re: Design proposal: fsync absorb linear slider

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: Design proposal: fsync absorb linear slider
Дата
Msg-id CA+Tgmoa-06jCUrAaOD2z3SXoPBgJWBBQq8dMPb9fK4Ch9MZtqw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Design proposal: fsync absorb linear slider  (didier <did447@gmail.com>)
Ответы Re: Design proposal: fsync absorb linear slider  (didier <did447@gmail.com>)
Список pgsql-hackers
Дерево обсуждения 
On Thu, Jul 25, 2013 at 6:02 PM, didier <did447@gmail.com> wrote:
> It was surely already discussed but why isn't postresql  writing
> sequentially its cache in a temporary file? With storage random speed at
> least five to ten time slower it could help a lot.
> Thanks

Sure, that's what the WAL does.  But you still have to checkpoint eventually.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: getting rid of SnapshotNow
Следующее
От: Fabrízio de Royes Mello
Дата:
Сообщение: Re: Patch to add support of "IF NOT EXISTS" to others "CREATE" statements