AW: Re: [GENERAL] Vacuum and Transactions - Mailing list pgsql-hackers

From Zeugswetter Andreas SB
Subject AW: Re: [GENERAL] Vacuum and Transactions
Date
Msg-id 11C1E6749A55D411A9670001FA687963368384@sdexcsrv1.f000.d0188.sd.spardat.at
Whole thread Raw
Responses Re: AW: Re: [GENERAL] Vacuum and Transactions
List pgsql-hackers
> I also think we have to leave VACUUM alone and come up with a new name
> for our light VACUUM.  That way, people who do VACUUM at night when no
> one is on the system can keep doing that, and just add something to run
> light vacuum periodically during the day.

If I understood what VACUUM light does, I do not think that people
will need to actually do the conventional VACUUM as often anymore.
I understood, that VACUUM light makes outdated tuple heap space available
for reuse, and removes the corresponding index entries.
It does not make space available to other tables or the OS,
but most other DB's do not do that eighter.
The conventional VACUUM would then be something you do as part of a DB 
reorganization (maybe once every month or so).

Andreas


pgsql-hackers by date:

Previous
From: Hiroshi Inoue
Date:
Subject: Re: Rule recompilation
Next
From: Zeugswetter Andreas SB
Date:
Subject: AW: Re: SOMAXCONN (was Re: Solaris source code)