Re: full_page_writes on SSD?

From: Kevin Grittner <kgrittn(at)gmail(dot)com>
To: Marcin Mańk <marcin(dot)mank(at)gmail(dot)com>
Cc: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: full_page_writes on SSD?
Date: 2015-11-24 19:09:58
Message-ID: CACjxUsNz8i+hUq6qm_eDf1SjMUNE9=cGpzv8tx+=xQbtyB1F+Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Nov 24, 2015 at 12:48 PM, Marcin Mańk <marcin(dot)mank(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andres Freund 2015-11-24 19:14:46 Re: full_page_writes on SSD?
Previous Message Marcin Mańk 2015-11-24 18:48:43 full_page_writes on SSD?