> On Nov 8, 2022, at 5:21 AM, Karthik Jagadish (kjagadis) <kjaga...@cisco.com>
> wrote:
>
> I didn’t get your point dead tuples are visible to transaction means?
> Vacuuming job is to remove dead tuples right?
Please see https://www.2ndquadrant.com/en/blog/when-autovacuum-does-not-vacuum/
for more information about your question. Specifically, you might look at the
third section down, "Long transactions", which starts with "So, if the table is
vacuumed regularly, surely it can’t accumulate a lot of dead rows, right?" You
might benefit from reading the entire article rather than skipping down to that
section.
I hope it helps....
—
Mark Dilger
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company