Re: Create Cluster --- Change the Block Size

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Ankush Chawla <ankushchawla03(at)gmail(dot)com>, pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Create Cluster --- Change the Block Size
Date: 2020-12-15 19:03:59
Message-ID: 250003f95a8fa8c18a070989a26b4b366cd13dff.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Tue, 2020-12-15 at 23:05 +0530, Ankush Chawla wrote:
> how to change the block size while creating the cluster

You cannot change the data file block size (8kB) during "initdb".
You'd have to recompile PostgreSQL for that and use
--with-blocksize=BLOCKSIZE with "configure".

I recommend not to do that.

But you can use --wal-segsize to set the WAL segment size during "initdb".

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Uwe.deReuter 2020-12-16 07:25:11 table lookup for pg_stat_progress_vacuum doesn't work
Previous Message Ron 2020-12-15 17:42:28 Re: Create Cluster --- Change the Block Size