AW: WAL does not recover gracefully from out-of-disk-sp ace

Поиск
Список
Период
Сортировка
От Zeugswetter Andreas SB
Тема AW: WAL does not recover gracefully from out-of-disk-sp ace
Дата
Msg-id 11C1E6749A55D411A9670001FA687963368236@sdexcsrv1.f000.d0188.sd.spardat.at
обсуждение исходный текст
Ответы Re: AW: WAL does not recover gracefully from out-of-disk-sp ace  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
> > Even with true fdatasync it's not obviously good for performance - it takes
> > too long time to write 16Mb files and fills OS buffer cache with trash-:(
> 
> True.  But at least the write is (hopefully) being done at a
> non-performance-critical time.

So you have non critical time every five minutes ?
Those platforms that don't have fdatasync won't profit anyway.
Even if the IO is done by postmaster the write to the disk has a severe
impact on concurrent other disk activity.
In a real 5 minutes checkpoint setup we are seriously talking about
48 Mb at least, or you risc foreground log creation. On systems I know,
that means 100% busying the disk for at least 8 seconds.

Andreas


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

Предыдущее
От: Karel Zak
Дата:
Сообщение: Re: Internationalized error messages
Следующее
От: Tatsuo Ishii
Дата:
Сообщение: Re: Internationalized error messages