Setting BLCKSZ 4kB - Mailing list pgsql-hackers

From sanyam jain
Subject Setting BLCKSZ 4kB
Date
Msg-id PN1PR01MB0653E14C09923D97136DB047C0EA0@PN1PR01MB0653.INDPRD01.PROD.OUTLOOK.COM
Whole thread Raw
Responses Re: Setting BLCKSZ 4kB
Re: Setting BLCKSZ 4kB
List pgsql-hackers

Hi,

I am trying to solve WAL flooding due to FPWs.


What are the cons of setting BLCKSZ as 4kB?


When saw the results published on http://blog.coelho.net/database/2014/08/17/postgresql-page-size-for-SSD-2.html

4kB page is giving better performance in comparison to 8kB except when tested with 15kB row size.


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


Thanks,

Sanyam Jain 

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: [HACKERS] generated columns
Next
From: Haribabu Kommi
Date:
Subject: Re: Enhance pg_stat_wal_receiver view to display connected host