full_page_writes on SSD?

From: Marcin Mańk <marcin(dot)mank(at)gmail(dot)com>
To: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: full_page_writes on SSD?
Date: 2015-11-24 18:48:43
Message-ID: CAK61fk7WXE2OZLHBP1kadHHJ9N8Wbbm8C=43cjyoMErwO=i64A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I saw this:
http://blog.pgaddict.com/posts/postgresql-on-ssd-4kb-or-8kB-pages

It made me wonder: 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?

Regards
Marcin Mańk

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kevin Grittner 2015-11-24 19:09:58 Re: full_page_writes on SSD?
Previous Message Dennis 2015-11-24 05:49:09 Re: JSON path wild cards?