Re: pgsql: Add relation fork support to pg_relation_size() function. - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: pgsql: Add relation fork support to pg_relation_size() function.
Date
Msg-id 48E9E947.7030708@enterprisedb.com
Whole thread Raw
In response to Re: pgsql: Add relation fork support to pg_relation_size() function.  (Gregory Stark <stark@enterprisedb.com>)
Responses Re: pgsql: Add relation fork support to pg_relation_size() function.
List pgsql-hackers
Gregory Stark wrote:
> Magnus Hagander <magnus@hagander.net> writes:
>> Heikki Linnakangas wrote:
>>> If we go with the ".fsm" extension, we'll get "12345.fsm.1" when the FSM
>>> grows large enough to be segmented. Does anyone have a problem with a
>>> filename with two dots? Shouldn't be a problem, I guess.
> 
> We could also just do 12345_fsm.1 like we do now but with the symbolic name.

or 12345fsm.1. I think 12345.fsm.1 looks the best.

FWIW, with the defaults of 8k block size and 1GB segments, the table 
needs to be over 4TB in size until the FSM file needs to be segmented.

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com


pgsql-hackers by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Weird behaviour with ALTER TABLE ... SET TABLESPACE ... statement
Next
From: Heikki Linnakangas
Date:
Subject: Re: Weird behaviour with ALTER TABLE ... SET TABLESPACE ... statement