Re: Setting BLCKSZ 4kB

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.