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

From: Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>
To: John Naylor <jcnaylor(at)gmail(dot)com>
Cc: Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: WIP: Avoid creation of the free space map for small tables
Date: 2018-10-05 20:42:26
Message-ID: CAEepm=3dfuAHv_v+K7VjhwyXHWEk14HshpavMrAt-oyVO-TwGQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sat, Oct 6, 2018 at 7:47 AM John Naylor <jcnaylor(at)gmail(dot)com> wrote:
> A while back, Robert Haas noticed that the space taken up by very
> small tables is dominated by the FSM [1]. Tom suggested that we could
> prevent creation of the FSM until the heap has reached a certain
> threshold size [2]. Attached is a WIP patch to implement that. I've
> also attached a SQL script to demonstrate the change in behavior for
> various scenarios.

Hi John,

You'll need to tweak the test in contrib/pageinspect/sql/page.sql,
because it's currently asserting that there is an FSM on a small table
so make check-world fails.

--
Thomas Munro
http://www.enterprisedb.com

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Keith Fiske 2018-10-05 20:43:39 Re: Create roles trigger
Previous Message Scott Whitney 2018-10-05 20:32:43 Re: Create roles trigger