Re: BUG #16016: deadlock with startup process, AccessExclusiveLockon pg_statistic's toast table - Mailing list pgsql-bugs

From Alexey Ermakov
Subject Re: BUG #16016: deadlock with startup process, AccessExclusiveLockon pg_statistic's toast table
Date
Msg-id 5DBDBD45.1020406@dataegret.com
Whole thread Raw
In response to Re: BUG #16016: deadlock with startup process, AccessExclusiveLock on pg_statistic's toast table  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
On 11/2/19 21:10, Tom Lane wrote:
> This does not look like a deadlock: the startup process is just biding
> its time until the standby delay timeout elapses, after which it's
> gonna kill the conflicting queries.
>
> It is, perhaps, arguable that it's a damn bad idea to allow
> max_standby_streaming_delay or max_standby_archive_delay to be
> set to "forever".
>
>

I agree, allowing max_standby_streaming_delay be set to -1 is perhaps
not a good idea. there is although case when such setting could be used
now, see "BUG #14044: Queries immediately conflict with recovery when 
recovery_min_apply_delay is used". [1]

[1] https://postgr.es/m/20160324204550.2920.87946%40wrigleys.postgresql.org

--
Alexey Ermakov



pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: ALTER TABLE results in "ERROR: could not open relation with OID 43707388"
Next
From: Tom Lane
Date:
Subject: Re: BUG #16059: Tab-completion of filenames in COPY commands removes required quotes