Re: Relation extension scalability - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Relation extension scalability
Date
Msg-id CA+TgmoYRP5-4YTMf1x1pNWVQrYW4_XUqGF1CsShU3_p0xg_GjQ@mail.gmail.com
Whole thread Raw
In response to Re: Relation extension scalability  (Petr Jelinek <petr@2ndquadrant.com>)
Responses Re: Relation extension scalability  (Petr Jelinek <petr@2ndquadrant.com>)
List pgsql-hackers
On Wed, Mar 23, 2016 at 2:52 PM, Petr Jelinek <petr@2ndquadrant.com> wrote:
>> Second, if the other backend extended the relation in
>> some other manner and did not extend the FSM, how does calling
>> RecordAndGetPageWithFreeSpace help?  As far as I can see,
>> GetPageWithFreeSpace and RecordAndGetPageWithFreeSpace are both just
>> searching the FSM, so if one is stymied the other will be too.  What
>> am I missing?
>>
>
> The RecordAndGetPageWithFreeSpace will extend FSM as it calls
> fsm_set_and_search which in turn calls fsm_readbuf with extend = true.

So how does that help?  If I'm reading this right, the new block will
be all zeroes which means no space available on any of those pages.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



pgsql-hackers by date:

Previous
From: Petr Jelinek
Date:
Subject: Re: Relation extension scalability
Next
From: Tom Lane
Date:
Subject: Re: PostgreSQL 9.6 behavior change with set returning (funct).*