Re: full_page_writes on SSD?

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: full_page_writes on SSD?
Дата
Msg-id CACjxUsNz8i+hUq6qm_eDf1SjMUNE9=cGpzv8tx+=xQbtyB1F+Q@mail.gmail.com
обсуждение исходный текст
Ответ на full_page_writes on SSD?  (Marcin Mańk <marcin.mank@gmail.com>)
Ответы Re: full_page_writes on SSD?  (Andres Freund <andres@anarazel.de>)
Список pgsql-general
On Tue, Nov 24, 2015 at 12:48 PM, Marcin Mańk <marcin.mank@gmail.com> wrote:

> if SSDs have 4kB/8kB sectors, and we'd make the Postgres page
> size equal to the SSD page size, do we still need full_page_writes?

If an OS write of the PostgreSQL page size has no chance of being
partially persisted (a/k/a torn), I don't think full page writes
are needed.  That seems likely to be true if pg page size matches
SSD sector size.

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


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

Предыдущее
От: Marcin Mańk
Дата:
Сообщение: full_page_writes on SSD?
Следующее
От: Andres Freund
Дата:
Сообщение: Re: full_page_writes on SSD?