Autovacuum on sys tables

2022-12-16 Thread Inzamam Shafiq
Dear Experts, Hope you are doing well. I have a question that autovacuum is running on sys tables like pg_class, pg_attribute, is it a normal thing? Further, what is dead tuples are not removed from Autovacuum, can we remove the dead tuples using FULL VACUUMM or pg_repack on sys tables? Thank

Re: Test if a database has any privilege granted to public

2022-12-16 Thread David G. Johnston
On Thu, Dec 15, 2022 at 5:17 PM Bryn Llewellyn wrote: > > There's no mention on the "Privileges" page of the > "has_database_privilege()" function. Nor of "aclexplode()". > Even now, I haven't managed a linear start to finish read of the entire PG > docs. And I found "has_database_privilege()"