pg.ddx.io  pgsql-committers@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Andrew Gierth <andrew@tao11.riddles.org.uk>
To: Amit Kapila <amit.kapila16@gmail.com>
Cc: Amit Kapila <akapila@postgresql.org>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Cc: John Naylor <john.naylor@2ndquadrant.com>
Cc: pgsql-committers@lists.postgresql.org
Subject: Re: pgsql: Avoid creation of the free space map for small heap relations.
Date: Mon, 28 Jan 2019 05:40:47 +0000
Message-ID: <8736pdjq73.fsf@news-spur.riddles.org.uk> (raw)
In-Reply-To: <CAA4eK1LjXLFZ0Q1mXO5h8b6Smw=hsDvT3ZLcw5wcXbC7TSuwEA@mail.gmail.com>
References: <E1gnwx4-0003C9-BR@gemulon.postgresql.org>
	<CAA4eK1KvRqjYYaYWpkb=g76uM=MkfN4xE4fN0S6dgwO0sj_jxA@mail.gmail.com>
	<CAA4eK1JntHd7X6dLJVPGYV917HejjhbMKXn9m_RnnCE162LbLA@mail.gmail.com>
	<877eepjt3p.fsf@news-spur.riddles.org.uk>
	<CAA4eK1LjXLFZ0Q1mXO5h8b6Smw=hsDvT3ZLcw5wcXbC7TSuwEA@mail.gmail.com>

>>>>> "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)




view thread (29+ messages)  latest in thread

Message-ID: <8736pdjq73.fsf@news-spur.riddles.org.uk>
Permalink:  ../8736pdjq73.fsf@news-spur.riddles.org.uk/
Also on:    postgresql.org/message-id/8736pdjq73.fsf@news-spur.riddles.org.uk

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-committers@postgresql.org
  Cc: andrew@tao11.riddles.org.uk, amit.kapila16@gmail.com, akapila@postgresql.org, pgsql-hackers@lists.postgresql.org, john.naylor@2ndquadrant.com, pgsql-committers@lists.postgresql.org
  Subject: Re: pgsql: Avoid creation of the free space map for small heap relations.
  In-Reply-To: <8736pdjq73.fsf@news-spur.riddles.org.uk>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox