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

From Andrew Gierth
Subject Re: pgsql: Avoid creation of the free space map for small heap relations.
Date
Msg-id 8736pdjq73.fsf@news-spur.riddles.org.uk
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 heap relations.
Re: pgsql: Avoid creation of the free space map for small heap relations.
List pgsql-hackers
>>>>> "Amit" == Amit Kapila <amit.kapila16@gmail.com> writes:

 Amit> Yes, so this could be the cause of the problem. I think we need
 Amit> to change the tests added by the patch such that they don't rely
 Amit> on vacuum to remove dead-row versions? Do you or anybody else see
 Amit> any better way to fix this?

Do 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.

-- 
Andrew (irc:RhodiumToad)


pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: pgsql: Avoid creation of the free space map for small heap relations.
Next
From: Tom Lane
Date:
Subject: Re: pgsql: Avoid creation of the free space map for small heap relations.