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

From Greg Stark
Subject Re: pgsql: Add relation fork support to pg_relation_size() function.
Date
Msg-id 4136ffa0810060348s7990cb2by6c2d383b2a5b1775@mail.gmail.com
Whole thread Raw
In response to Re: pgsql: Add relation fork support to pg_relation_size() function.  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Responses Re: pgsql: Add relation fork support to pg_relation_size() function.
List pgsql-hackers
On Mon, Oct 6, 2008 at 11:32 AM, Heikki Linnakangas
<heikki.linnakangas@enterprisedb.com> wrote:
>
> 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.

Hm, so on the one hand people will just have 12345.1, 12345.2, ... and
12345.fsm which is kind of neat.

On the other hand if they do have a problem with multiple periods they
won't find out until they have a pretty big database already and are
kind of stuck. And our regression tests won't test it at all.

-- 
greg


pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Weird behaviour with ALTER TABLE ... SET TABLESPACE ... statement
Next
From: iihero
Date:
Subject: Re: About postgresql8.3.3 build in MS VS2005