Re: pgsql: Add relation fork support to pg_relation_size() function.

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: pgsql: Add relation fork support to pg_relation_size() function.
Дата
Msg-id 48E9E947.7030708@enterprisedb.com
обсуждение исходный текст
Ответ на Re: pgsql: Add relation fork support to pg_relation_size() function.  (Gregory Stark <stark@enterprisedb.com>)
Ответы Re: pgsql: Add relation fork support to pg_relation_size() function.  ("Greg Stark" <stark@enterprisedb.com>)
Список 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 по дате отправления:

Предыдущее
От: Guillaume Lelarge
Дата:
Сообщение: Weird behaviour with ALTER TABLE ... SET TABLESPACE ... statement
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Weird behaviour with ALTER TABLE ... SET TABLESPACE ... statement