Re: subscriptionCheck failures on nightjar

Поиск
Список
Период
Сортировка
От Tomas Vondra
Тема Re: subscriptionCheck failures on nightjar
Дата
Msg-id 20190920153048.wpe27ht5lcs3zlrm@development
обсуждение исходный текст
Ответ на Re: subscriptionCheck failures on nightjar  (Michael Paquier <michael@paquier.xyz>)
Ответы Re: subscriptionCheck failures on nightjar  (Michael Paquier <michael@paquier.xyz>)
Список 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 по дате отправления:

Предыдущее
От: Tomas Vondra
Дата:
Сообщение: Re: WAL recycled despite logical replication slot
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Allow CLUSTER, VACUUM FULL and REINDEX to change tablespace onthe fly