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 20221109194217.jhimtlnp6y7hbbcn@awork3.anarazel.de
Whole thread Raw
In response to Re: allow segment size to be set to < 1GiB  (Andres Freund <andres@anarazel.de>)
Responses Re: allow segment size to be set to < 1GiB
List pgsql-hackers
On 2022-11-08 18:28:08 -0800, Andres Freund wrote:
> On 2022-11-07 21:36:33 -0500, Tom Lane wrote:
> > Andres Freund <andres@anarazel.de> writes:
> > > On 2022-11-07 12:52:25 -0500, Tom Lane wrote:
> > >> How about instead allowing the segment size to be set in pages?
> > 
> > > In addition or instead of --with-segsize/-Dsegsize?
> > 
> > In addition to.  What I meant by "instead" was to replace
> > your proposal of --with-segsize-mb.
> 
> Working on updating the patch.
> 
> One semi-interesting bit is that <= 5 blocks per segment fails, because
> corrupt_page_checksum() doesn't know about segments and
> src/bin/pg_basebackup/t/010_pg_basebackup.pl does

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. We could show kB, but that ends up being large. Or we
can have some code to adjust the unit, but that seems a bit overkill.

Opinions?



pgsql-hackers by date:

Previous
From: "Daniel Verite"
Date:
Subject: Re: psql: Add command to use extended query protocol
Next
From: Tom Lane
Date:
Subject: Re: allow segment size to be set to < 1GiB