Hi Venkata, No there are no other connections to the DB during vacuum.
Regards, Granthana On Fri, Mar 21, 2014 at 3:12 AM, Venkata Balaji Nagothi <vbn...@gmail.com>wrote: > 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 > >
