From: | John Naylor <jcnaylor(at)gmail(dot)com> |
---|---|
To: | Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> |
Cc: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: WIP: Avoid creation of the free space map for small tables |
Date: | 2018-12-06 17:23:28 |
Message-ID: | CAJVSVGWR8mH8HKYaxNw3r9_trXXcwEYoW_sst8XbK_dZi_KNuw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 12/3/18, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> wrote:
> On Mon, Dec 3, 2018 at 11:15 AM John Naylor <jcnaylor(at)gmail(dot)com> wrote:
>> Per your recent comment, we no longer check relation size if we waited
>> on a relation extension lock, so this is essentially a reversion to an
>> earlier version.
>>
>
> fsm_local_set is being called from RecordAndGetPageWithFreeSpace and
> GetPageWithFreeSpace whereas the change we have discussed was specific
> to GetPageWithFreeSpace, so not sure if we need any change in
> fsm_local_set.
Not needed, but I assumed wrongly you'd think it unclear otherwise.
I've now restored the generality and updated the comments to be closer
to v8.
> It would be good if you add few comments atop functions
> GetPageWithFreeSpace, RecordAndGetPageWithFreeSpace and
> RecordPageWithFreeSpace about their interaction with local map.
Done. Also additional minor comment editing.
I've added an additional regression test for finding the right block
and removed a test I thought was redundant. I've kept the test file in
its own schedule.
-John Naylor
Attachment | Content-Type | Size |
---|---|---|
v10-0001-Avoid-creation-of-the-free-space-map-for-small-t.patch | text/x-patch | 36.3 KB |
v10-0002-During-pg_upgrade-skip-transfer-of-FSMs-if-they.patch | text/x-patch | 7.4 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Pavel Stehule | 2018-12-06 17:27:57 | Re: proposal: plpgsql pragma statement |
Previous Message | Robert Haas | 2018-12-06 17:16:55 | Re: proposal: plpgsql pragma statement |