Re: full_page_writes on SSD? - Mailing list pgsql-general

From Kevin Grittner
Subject Re: full_page_writes on SSD?
Date
Msg-id CACjxUsNz8i+hUq6qm_eDf1SjMUNE9=cGpzv8tx+=xQbtyB1F+Q@mail.gmail.com
Whole thread Raw
In response to full_page_writes on SSD?  (Marcin Mańk <marcin.mank@gmail.com>)
Responses Re: full_page_writes on SSD?
List 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 by date:

Previous
From: Marcin Mańk
Date:
Subject: full_page_writes on SSD?
Next
From: Andres Freund
Date:
Subject: Re: full_page_writes on SSD?