Re: Setting BLCKSZ 4kB - Mailing list pgsql-hackers

From Andres Freund
Subject Re: Setting BLCKSZ 4kB
Date
Msg-id 20180126230621.fzwz2rwjal4mqg43@alap3.anarazel.de
Whole thread Raw
In response to Re: Setting BLCKSZ 4kB  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Responses Re: Setting BLCKSZ 4kB
List 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 by date:

Previous
From: Fabien COELHO
Date:
Subject: Re: PATCH: pgbench - option to build using ppoll() for largerconnection counts
Next
From: Daniel Gustafsson
Date:
Subject: Re: [HACKERS] Refactoring identifier checks to consistently use strcmp