Re: autovacuum freeze recommendations at table level

2024-08-12 Thread semab tariq
Hi Durga *autovacuum_freeze_max_age* specifies the maximum age (in transactions) that a table's tuples can reach before a vacuum is forced to prevent transaction ID wraparound. when the age of the oldest tuple in the table exceeds this value, an autovacuum is triggered to freeze the tuples. *Recom

Re: Monitoring DB size

2024-07-31 Thread semab tariq
Hi Manuel Sorry for the late reply saw this email just today. Anyways how about using something like? postgres=# SELECT postgres-# pg_size_pretty(pg_database_size('postgres')) AS database_size, postgres-# pg_size_pretty(pg_total_relation_size('accounts')) AS table_size, postgres-# pg_