Re: subscriptionCheck failures on nightjar - Mailing list pgsql-hackers

From Tomas Vondra
Subject Re: subscriptionCheck failures on nightjar
Date
Msg-id 20190920153048.wpe27ht5lcs3zlrm@development
Whole thread Raw
In response to Re: subscriptionCheck failures on nightjar  (Michael Paquier <michael@paquier.xyz>)
Responses Re: subscriptionCheck failures on nightjar
List pgsql-hackers
On Thu, Sep 19, 2019 at 01:23:05PM +0900, Michael Paquier wrote:
>On Wed, Sep 18, 2019 at 11:58:08PM +0200, Tomas Vondra wrote:
>> I kinda suspect it might be just a coincidence that it fails during that
>> particular test. What likely plays a role here is a checkpoint timing
>> (AFAICS that's the thing removing the file).  On most systems the tests
>> complete before any checkpoint is triggered, hence no issue.
>>
>> Maybe aggressively triggering checkpoints on the running cluter from
>> another session would do the trick ...
>
>Now that I recall, another thing I forgot to mention on this thread is
>that I patched guc.c to reduce the minimum of checkpoint_timeout to
>1s.

But even with that change you haven't managed to reproduce the issue,
right? Or am I misunderstanding?

regarss

-- 
Tomas Vondra                  http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services 



pgsql-hackers by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: WAL recycled despite logical replication slot
Next
From: Alvaro Herrera
Date:
Subject: Re: Allow CLUSTER, VACUUM FULL and REINDEX to change tablespace onthe fly