Re: postgres_fdw: perform UPDATE/DELETE .. RETURNING on a join directly

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: postgres_fdw: perform UPDATE/DELETE .. RETURNING on a join directly
Дата
Msg-id 29147.1519769644@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: postgres_fdw: perform UPDATE/DELETE .. RETURNING on a join directly  (Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>)
Ответы Re: postgres_fdw: perform UPDATE/DELETE .. RETURNING on a join directly
Список pgsql-hackers
Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp> writes:
> (2018/02/11 6:24), Tom Lane wrote:
>> However, jaguarundi still shows a problem:
>> https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=jaguarundi&dt=2018-02-10%2008%3A41%3A32

> I ran the postgres_fdw regression test with no sleep two times in a
> CLOBBER_CACHE_ALWAYS-enabled build, and then the regression test with
> the sleep (60 seconds) two times, but I couldn't reproduce that in both
> cases.  I suspect the changes in the order of the RETURNING output there
> was still caused by autovacuum kicking in partway through the run.  So
> to make the regression test more stable against autovacuum, I'd propose
> to modify the regression test to disable autovacuum for the remote table
> (ie "S 1"."T 1") (and perform VACUUM ANALYZE to that table manually
> instead) in hopes of getting that fixed.  Attached is a patch for that.
>   I think changes added by the previous patch wouldn't make sense
> anymore, so I removed those changes.

Ping?  We're still seeing those failures on jaguarundi.

            regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Peter Geoghegan
Дата:
Сообщение: Re: [HACKERS] MERGE SQL Statement for PG11
Следующее
От: Greg Stark
Дата:
Сообщение: Re: Reopen logfile on SIGHUP