Re: Vacuum full issue - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Vacuum full issue
Date
Msg-id 1dbe2a36-6432-13ff-21b6-7b82158004be@aklaver.com
Whole thread Raw
In response to Vacuum full issue  (Rama Krishnan <raghuldrag@gmail.com>)
List pgsql-general
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




pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Vacuum full issue
Next
From: Peter Geoghegan
Date:
Subject: Re: Automatic aggressive vacuum on almost frozen table takes too long