Re: Large files for relations - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Large files for relations
Date
Msg-id 51392a30-1e86-efb4-41e5-6e52d423b32d@enterprisedb.com
Whole thread Raw
In response to Re: Large files for relations  (Thomas Munro <thomas.munro@gmail.com>)
List pgsql-hackers
On 28.05.23 02:48, Thomas Munro wrote:
> Another potential option name would be --segsize, if we think we're
> going to use this for temp files too eventually.
> 
> Maybe it's not so beautiful to have that global variable
> rel_segment_size (which replaces REL_SEGSIZE everywhere).  Another
> idea would be to make it static in md.c and call smgrsetsegmentsize(),
> or something like that.

I think one way to look at this is that the segment size is a 
configuration property of the md.c smgr.  I have been thinking a bit 
about how smgr-level configuration could look.  You can't use a catalog 
table, but we also can't have smgr plugins get space in pg_control.

Anyway, I'm not asking you to design this now.  A global variable via 
pg_control seems fine for now.  But it wouldn't be an smgr API call, I 
think.



pgsql-hackers by date:

Previous
From: vignesh C
Date:
Subject: Re: Support logical replication of DDLs
Next
From: "Mayer, Nicholas J"
Date:
Subject: Question - Does PostgreSQL have an Evaluation Assurance Level?