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

John Naylor <john.naylor@2ndquadrant.com>

From: John Naylor <john.naylor@2ndquadrant.com>

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

Cc: Sawada Masahiko <sawada.mshk@gmail.com>, Mithun Cy <mithun.cy@enterprisedb.com>, pgsql-hackers <pgsql-hackers@postgresql.org>

Date: 2019-01-30T09:56:32Z

Lists: pgsql-hackers

Attachments

remove-reliance-on-vacuum-for-fsm-regression-test.patch (text/x-patch) patch

On Wed, Jan 30, 2019 at 4:33 AM Amit Kapila <amit.kapila16@gmail.com> wrote:
> There are two more failures which we need to something about.
> 1. Make fsm.sql independent of vacuum without much losing on coverage
> of newly added code.  John, I guess you have an idea, see if you can
> take care of it, otherwise, I will see what I can do for it.

I've attached a patch that applies on top of v19 that uses Andrew
Gierth's idea to use fillfactor to control free space. I've also
removed tests that relied on truncation and weren't very useful to
begin with.

--
John Naylor                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

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