Re: Setting BLCKSZ 4kB

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: Setting BLCKSZ 4kB
Дата
Msg-id 20180126230621.fzwz2rwjal4mqg43@alap3.anarazel.de
обсуждение исходный текст
Ответ на Re: Setting BLCKSZ 4kB  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Ответы Re: Setting BLCKSZ 4kB
Список pgsql-hackers
Hi,

On 2018-01-26 23:53:33 +0100, Tomas Vondra wrote:
> But more importantly, I don't see why the size of the internal page
> would matter here at all? SSDs have non-volatile write cache (DRAM with
> battery), protecting all the internal writes to pages. If your SSD does
> not do that correctly, it's already broken no matter what page size it
> uses even with full_page_writes=on.

Far far from all SSDs have non-volatile write caches. And if they
respect barrier requests (i.e. flush before returning), they're not
broken.

Greetings,

Andres Freund


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

Предыдущее
От: Fabien COELHO
Дата:
Сообщение: Re: PATCH: pgbench - option to build using ppoll() for largerconnection counts
Следующее
От: Daniel Gustafsson
Дата:
Сообщение: Re: [HACKERS] Refactoring identifier checks to consistently use strcmp