Standby reads fail when autovacuum take AEL during truncation - Mailing list pgsql-hackers

From Adrien NAYRAT
Subject Standby reads fail when autovacuum take AEL during truncation
Date
Msg-id 4923b69f-43eb-e7cd-bcf4-37229268e6c0@anayrat.info
Whole thread Raw
Responses Re: Standby reads fail when autovacuum take AEL during truncation  (Alexander Korotkov <a.korotkov@postgrespro.ru>)
List pgsql-hackers
Hello hackers,

I was faced on $SUBJECT  on an heavily updated table and the same table 
heavily accessed on standby server.

I notice autovacuum try to take an AEL in lazy_truncate_heap(). On 
primary we try during VACUUM_TRUNCATE_LOCK_WAIT_INTERVAL (50ms) and we 
failed after several attempts.

But we do not have this mechanism on a standby, AEL could lock simple 
SELECT during the RelationTruncate().

Please note, this can occurs even with hot_standby_feedback = on

I wonder how we can improve this? Maybe by introducing an option to 
disable truncation for autovacuum on specific table?

Thanks!



pgsql-hackers by date:

Previous
From: Peter Moser
Date:
Subject: Re: [HACKERS] [PROPOSAL] Temporal query processing with range types
Next
From: Fabien COELHO
Date:
Subject: Re: [HACKERS] proposal: schema variables