Bug #21030
Updated by Peter Amstutz about 1 year ago
Reported that permission updates on a large / busy cluster get slower and slower over time. Doing a "VACUUM FULL" fixes it but the slowness comes back after a few days.
Currently speculating that it may be due to the fact that every request that updates permission, trashed projects, or frozen projects currently creates a temporary table.
https://stackoverflow.com/questions/50366509/temporary-tables-bloating-pg-attribute
https://stackoverflow.com/questions/65035281/bloating-of-pg-attribute-caused-by-repetitive-temporary-table-creations