Re: Vacuum Full does not release the disk size space after delete from table

2018-11-04 Thread Haozhou Wang
Thank Tom! We will check it. On Fri, Nov 2, 2018 at 10:35 PM Tom Lane wrote: > Haozhou Wang writes: > > We meet a corner case that related to the behavior of Vacuum Full. > > ... > > If we run both sql scripts on same database in parallel, the "VACUUM FULL > > a;" will not release the disk spac

Re: Vacuum Full does not release the disk size space after delete from table

2018-11-02 Thread Tom Lane
Haozhou Wang writes: > We meet a corner case that related to the behavior of Vacuum Full. > ... > If we run both sql scripts on same database in parallel, the "VACUUM FULL > a;" will not release the disk space. I think what's happening is that the delete in script 1 happens after the "pg_sleep" i