On Thu, Mar 20, 2014 at 5:27 AM, Granthana Biswas <granth...@zedo.com>wrote:
Hello All, > > Has anyone ever faced the issue of dead rows not getting removed during > vacuum even if there are no open transactions/connections? > > We have been facing this during every scheduled vacuum which is done after > closing all other database connections: > > 119278 dead row versions cannot be removed yet. > > This means there are transactions in progress when the vacuum was running. Do you see any such situation ? Please let us know, which version of PostgreSQL is this. Venkata Balaji N Sr. Database Administrator Fujitsu Australia
