Re: allow segment size to be set to < 1GiB - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: allow segment size to be set to < 1GiB
Date
Msg-id 714f98c1-7077-8ad7-364a-9570ba16c00f@dunslane.net
Whole thread Raw
In response to Re: allow segment size to be set to < 1GiB  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On 2022-11-17 Th 10:48, Tom Lane wrote:
> Andres Freund <andres@anarazel.de> writes:
>> On 2022-11-17 09:58:48 -0500, Andrew Dunstan wrote:
>>> Are we going to impose some sane minimum, or leave it up to developers
>>> to discover that for themselves?
>> I don't think we should. It's actually useful to e.g. use 1 page sized
>> segments for testing, and with one exceptions the tests pass with it too. Do
>> you see a reason to impose one?
> Yeah, I think we should allow setting it to 1 block.  This switch is
> only for testing purposes (I hope the docs make that clear).
>
>             


Yeah clearly if 1 is useful there's no point in limiting it.


cheers


andrew

--
Andrew Dunstan
EDB: https://www.enterprisedb.com




pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: Fix proposal for comparaison bugs in PostgreSQL::Version
Next
From: Tom Lane
Date:
Subject: Re: Don't treate IndexStmt like AlterTable when DefineIndex is called from ProcessUtilitySlow.