Re: WIP: Avoid creation of the free space map for small tables

John Naylor <jcnaylor@gmail.com>

View thread View on postgr.es

From: John Naylor <jcnaylor@gmail.com>

To: Amit Kapila <amit.kapila16@gmail.com>

Cc: Mithun Cy <mithun.cy@enterprisedb.com>, pgsql-hackers <pgsql-hackers@postgresql.org>

Date: 2019-01-07T20:56:59Z

Lists: pgsql-hackers

Attachments

fsm-last-page-only.patch (text/x-patch) patch
fsm-every-other-page.patch (text/x-patch) patch

On 1/3/19, Amit Kapila <amit.kapila16@gmail.com> wrote:
> Yeah, that makes sense, John, can you provide a patch on top of the
> current patch where we check either the last block or every other
> block.

I've attached two patches for testing. Each one applies on top of the
current patch.

Mithun, I'll respond to your other review comments later this week.

-John Naylor

Commits

Improve code comments in b0eaa4c51b.
- 06c8a5090ed9 12.0 landed
During pg_upgrade, conditionally skip transfer of FSMs.
- 13e8643bfc29 12.0 landed
Add more tests for FSM.
- 6f918159a97a 12.0 landed
Doc: Update the documentation for FSM behavior for small tables.
- 29d108cdecbe 12.0 landed
Make FSM test portable.
- 08ecdfe7e5e0 12.0 landed
Avoid creation of the free space map for small heap relations, take 2.
- b0eaa4c51bbf 12.0 landed
Move page initialization from RelationAddExtraBlocks() to use, take 2.
- 0d1fe9f74e36 12.0 cited
Avoid creation of the free space map for small heap relations.
- ac88d2962a96 12.0 landed
In bootstrap mode, don't allow the creation of files if they don't already
- d66e3664b8ba 12.0 landed