Request a Demo
Home   >   mailing lists

Re: Parallel autovacuum: DROP DATABASE WITH (FORCE) fails on the parallel workers - Mailing list pgsql-hackers

From shihao zhong
Subject Re: Parallel autovacuum: DROP DATABASE WITH (FORCE) fails on the parallel workers
Date
Msg-id CAGRkXqS0G1oHMeoXyrj51YFo2LBjC4wU6pM3ih7DhWo1mie7rg@mail.gmail.com
Whole thread
In response to Re: Parallel autovacuum: DROP DATABASE WITH (FORCE) fails on the parallel workers  (Masahiko Sawada <sawada.mshk@gmail.com>)
Responses Re: Parallel autovacuum: DROP DATABASE WITH (FORCE) fails on the parallel workers
List pgsql-hackers
Tree view
Hi Sawada-san,

Attached v5 drops the lock and adds a comment on why the read is safe.
It also adds the !OidIsValid(leader->roleId) check and sets roleId to
InvalidOid directly, so only a leader with no advertised role changes
anything.

Thanks,
Shihao
Attachment

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: pgstat: allow a stats kind to use its own dedicated dsa/dshash
Next
From: Alexander Lakhin
Date:
Subject: 041_checkpoint_at_promote.pl might fail due to race condition on child kill