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

From Andres Freund
Subject Re: allow segment size to be set to < 1GiB
Date
Msg-id 20221117153910.oqy4mrks44i66ee7@awork3.anarazel.de
Whole thread Raw
In response to Re: allow segment size to be set to < 1GiB  (Andrew Dunstan <andrew@dunslane.net>)
Responses Re: allow segment size to be set to < 1GiB
List pgsql-hackers
Hi,

On 2022-11-17 09:58:48 -0500, Andrew Dunstan wrote:
> On 2022-11-09 We 15:25, Andres Freund wrote:
> > Hi,
> >
> > On 2022-11-09 14:44:42 -0500, Tom Lane wrote:
> >> Andres Freund <andres@anarazel.de> writes:
> >>> A second question: Both autoconf and meson print the segment size as GB right
> >>> now. Obviously that'll print out a size of 0 for a segsize < 1GB.
> >>> The easiest way to would be to just display the number of blocks, but that's
> >>> not particularly nice.
> >> Well, it would be fine if you'd written --with-segsize-blocks, wouldn't
> >> it?  Can we make the printout format depend on which switch was used?
> > Not sure why I didn't think of that...
> >
> > Updated patch attached.
> >
> > I made one autoconf and one meson CI task use a small block size, but just to
> > ensure it work on both. I'd probably leave it set on one, so we keep the
> > coverage for cfbot?
> >
> 
> 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?

Greetings,

Andres Freund



pgsql-hackers by date:

Previous
From: Justin Pryzby
Date:
Subject: Re: Introduce "log_connection_stages" setting.
Next
From: Andres Freund
Date:
Subject: Re: [PoC] configurable out of disk space elog level