Artem Tomyuk wrote:
> Why autovacuum cant delete those rows?
Either long running transactions (check pg_stat_activity)
or prepared transactions (check pg_prepared_xacts)
or stale replication slots (check pg_replication_slots).
> What is the main reason that pg_attribute getting bloated?
Creating and dropping many (maybe temporary) tables.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com