Re: Maintenance

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]


vrms you are correct.

On Wed, 8 May, 2024, 7:59 pm vrms, <vrms@xxxxxxxxxxxxx> wrote:

On 5/8/24 3:10 PM, Ron Johnson wrote:

> Don't dead tuples have to be vacuumed away before the space can be reused?

I think that is correct. As per my understanding ...


   - removes dead tuples and makes the consumed space available for future data
   - does not free disk space
   - does not cause any locks


   - removes dead tuples and frees actual disk space
   - causes locks on the table being VACUUMed

[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux