Setting BLCKSZ 4kB

From: sanyam jain <sanyamjain22(at)live(dot)in>
To: Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Setting BLCKSZ 4kB
Date: 2018-01-16 06:50:05
Message-ID: PN1PR01MB0653E14C09923D97136DB047C0EA0@PN1PR01MB0653.INDPRD01.PROD.OUTLOOK.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Haribabu Kommi 2018-01-16 06:56:22 Re: Enhance pg_stat_wal_receiver view to display connected host
Previous Message Michael Paquier 2018-01-16 06:35:46 Re: [HACKERS] generated columns