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 04:55:06 +0000
Message-ID: <877eepjt3p.fsf@news-spur.riddles.org.uk> (raw)
In-Reply-To: <CAA4eK1JntHd7X6dLJVPGYV917HejjhbMKXn9m_RnnCE162LbLA@mail.gmail.com>
References: <E1gnwx4-0003C9-BR@gemulon.postgresql.org>
<CAA4eK1KvRqjYYaYWpkb=g76uM=MkfN4xE4fN0S6dgwO0sj_jxA@mail.gmail.com>
<CAA4eK1JntHd7X6dLJVPGYV917HejjhbMKXn9m_RnnCE162LbLA@mail.gmail.com>
>>>>> "Amit" == Amit Kapila <amit.kapila16@gmail.com> writes:
Amit> One possibility is that autovacuum has triggered to perform
Amit> truncation of some other relation (remove pages at the end) which
Amit> doesn't allow the FSM test to remove the rows/perform truncation
Amit> and thus let to the failure. Can there be anything else which can
Amit> start a transaction when a regression test is running? Still
Amit> thinking, but inputs are welcome.
I've bumped into issues (cf. commit 64ae420b2) with regression tests of
this kind caused by concurrent (auto-)ANALYZE (not VACUUM); VACUUM's
snapshot is ignored for testing for whether row versions can be removed,
but ANALYZE's is not.
--
Andrew (irc:RhodiumToad)
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: <877eepjt3p.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