Magnus Hagander <magnus@xxxxxxxxxxxx> writes: > On Tue, Jun 30, 2020 at 12:17 AM Bill Glennon <wglennon@xxxxxxxxx> wrote: >> If you are building a Postgresql database from source and you use >> option --with-segsize=4, how do you verify that the database segsize is 4GB >> and not the default 1GB? Is there a query that you can run? > You can run the query "SHOW segment_size" to show the compiled-in value. pg_controldata will show it too, though a bit more opaquely: Blocks per segment of large relation: 131072 This would be helpful if you have an on-disk database and no running server. regards, tom lane
