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

From Fabien COELHO
Subject Re: Setting BLCKSZ 4kB
Date
Msg-id alpine.DEB.2.20.1801171334080.11884@lancre
Whole thread Raw
In response to Setting BLCKSZ 4kB  (sanyam jain <sanyamjain22@live.in>)
Responses Re: Setting BLCKSZ 4kB
List pgsql-hackers
Hello,

> What are the cons of setting BLCKSZ as 4kB? When saw the results 
> published on [...].

There were other posts and publications which points to the same direction 
consistently.

This matches my deep belief is that postgres default block size is a 
reasonable compromise for HDD, but is less pertinent for SSD for most OLTP 
loads.

For OLAP, I do not think it would lose much, but I have not tested it.

> Does turning off FPWs will be safe if BLCKSZ is set to 4kB given page 
> size of file system is 4kB?

FPW = Full Page Write. I would not bet on turning off FPW, ISTM that SSDs 
can have "page" sizes as low as 512 bytes, but are typically 2 kB or 4 kB, 
and the information easily available anyway.

-- 
Fabien.


pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: [HACKERS] Another oddity in handling of WCO constraints inpostgres_fdw
Next
From: Amit Kapila
Date:
Subject: Re: [HACKERS] Parallel tuplesort (for parallel B-Tree index creation)