Re: pgsql: Avoid creation of the free space map for small heap relations. - Mailing list pgsql-hackers

From John Naylor
Subject Re: pgsql: Avoid creation of the free space map for small heap relations.
Date
Msg-id CACPNZCtP6QRrFYsGhv7V4OJT5Lsa5GL6pt1rhMGQmPk58UnTYQ@mail.gmail.com
Whole thread Raw
In response to Re: pgsql: Avoid creation of the free space map for small heap relations.  (Amit Kapila <amit.kapila16@gmail.com>)
Responses Re: pgsql: Avoid creation of the free space map for small heaprelations.  (Michael Paquier <michael@paquier.xyz>)
Re: pgsql: Avoid creation of the free space map for small heaprelations.  (Michael Paquier <michael@paquier.xyz>)
List pgsql-hackers
On Mon, Jan 28, 2019 at 6:58 AM Amit Kapila <amit.kapila16@gmail.com> wrote:
>
> On Mon, Jan 28, 2019 at 11:10 AM Andrew Gierth
> you just need to create free space on a page that didn't have enough
> > before? It might be worth tweaking the fillfactor rather than trying to
> > delete anything.
> >
>
> No, it also depends on vacuum to remove rows and then truncate the
> relation accordingly.

That particular test could be removed -- it's just verifying behavior
that's already been there for years and is a direct consquence of
normal truncation combined with the addressing scheme of the FSM
logic.

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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: pgsql: Avoid creation of the free space map for small heap relations.
Next
From: Michael Paquier
Date:
Subject: Re: Tab completion for ALTER INDEX|TABLE ALTER COLUMN SET STATISTICS