Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gnyx1-0003ch-7O for pgsql-committers@arkaria.postgresql.org; Mon, 28 Jan 2019 04:55:15 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gnywz-0000GS-W5 for pgsql-committers@arkaria.postgresql.org; Mon, 28 Jan 2019 04:55:13 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gnywz-0000Dy-Mq; Mon, 28 Jan 2019 04:55:13 +0000 Received: from lungold.riddles.org.uk ([82.68.208.19]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gnyww-0000lx-JI; Mon, 28 Jan 2019 04:55:12 +0000 Received: from [192.168.127.1] (port=37171 helo=caithnard.riddles.org.uk) by lungold.riddles.org.uk with esmtps (TLSv1.2:ECDHE-RSA-AES256-GCM-SHA384:256) (Exim 4.88 (FreeBSD)) (envelope-from ) id 1gnyws-0001Tc-SJ; Mon, 28 Jan 2019 04:55:06 +0000 Received: from [127.0.0.1] (port=27894 helo=caithnard.riddles.org.uk) by caithnard.riddles.org.uk with esmtp (Exim 4.89 (FreeBSD)) (envelope-from ) id 1gnyws-000CjO-7B; Mon, 28 Jan 2019 04:55:06 +0000 From: Andrew Gierth To: Amit Kapila Cc: Amit Kapila , PostgreSQL Hackers , John Naylor , pgsql-committers@lists.postgresql.org Subject: Re: pgsql: Avoid creation of the free space map for small heap relations. In-Reply-To: (Amit Kapila's message of "Mon, 28 Jan 2019 09:47:00 +0530") Message-ID: <877eepjt3p.fsf@news-spur.riddles.org.uk> References: User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/25.1 (berkeley-unix) Date: Mon, 28 Jan 2019 04:55:06 +0000 MIME-Version: 1.0 Content-Type: text/plain List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk >>>>> "Amit" == Amit Kapila 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)