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.
