Re: pgsql: Fix "base" snapshot handling in logical decoding - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: pgsql: Fix "base" snapshot handling in logical decoding
Date
Msg-id 20180629222906.w5hqjgclmtk76v5i@alvherre.pgsql
Whole thread Raw
Responses Re: pgsql: Fix "base" snapshot handling in logical decoding
List pgsql-hackers
On 2018-Jun-28, Tom Lane wrote:

> Alvaro Herrera <alvherre@alvh.no-ip.org> writes:
> > Fix "base" snapshot handling in logical decoding
> 
> According to buildfarm member friarbird, and as confirmed here,
> the contrib/test_decoding/specs/oldest_xmin.spec test added by this
> commit fails under CLOBBER_CACHE_ALWAYS.

Hm.  Running this test under CLOBBER_CACHE_ALWAYS I see that the VACUUM
FULL step takes 31 seconds (and the test succeeds).  This is not
top-of-the-line hardware by a long shot (Intel(R) Core(TM) i7-4600U CPU
@ 2.10GHz) but I can believe that the other machines are slower or
busier.

Or there might be a completely different explanation ...

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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Internal error XX000 with enable_partition_pruning=on, pg 11 beta1 on Debian
Next
From: Alvaro Herrera
Date:
Subject: Re: Explain buffers wrong counter with parallel plans