> On Nov 8, 2022, at 5:21 AM, Karthik Jagadish (kjagadis) <kjagadis@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
tableis vacuumed regularly, surely it can’t accumulate a lot of dead rows, right?" You might benefit from reading the
entirearticle rather than skipping down to that section.
I hope it helps....
—
Mark Dilger
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company