Vacuum full issue
Hi All,
One of my friend project they did vacuum full last week since one of the
table column data type were CLOB after that activity the dev team found out
some of the data were missing or corrupt (XML) , please explain me will
vacuum full have any limitation like that?
Thanks
Ramakrishnan
On Thu, Feb 16, 2023 at 12:24 PM Rama Krishnan <raghuldrag@gmail.com> wrote:
One of my friend project they did vacuum full last week since one of the
table column data type were CLOB after that activity the dev team found out
some of the data were missing or corrupt (XML) , please explain me will
vacuum full have any limitation like that?
No, vacuum full is not designed to destroy xml data that has been stored in
the database.
David J.
On 2/16/23 05:18, Rama Krishnan wrote:
Hi All,
One of my friend project they did vacuum full last week since one of
the table column data type were CLOB after that activity the dev team
found out some of the data were missing or corrupt (XML) , please
explain me will vacuum full have any limitation like that?
I'm guessing this has to do with whatever condition caused then to
decide to do VACUUM FULL in the first place.
Why did they do the VACUUM FULL?
Thanks
Ramakrishnan
--
Adrian Klaver
adrian.klaver@aklaver.com