Hi, On Thu, Jun 18, 2026 at 10:16 AM Jeyaprakash Rajamani <[email protected]> wrote: > > But why doesn't VACUUM remove the dead tuples? We also checked at that time > and confirmed there are no long running, active transactions or replication > slots.
You may need to look at the VACUUM verbose output - it would tell you exactly how many dead tuples/pages are present but not removable and what's the oldest-xmin (which vacuum uses to decide whether or not to remove the dead tples) etc. -- Bharath Rupireddy Amazon Web Services: https://aws.amazon.com
