AW: Re: [GENERAL] Vacuum and Transactions

From: Zeugswetter Andreas SB <ZeugswetterA(at)wien(dot)spardat(dot)at>
To: "'Bruce Momjian'" <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: AW: Re: [GENERAL] Vacuum and Transactions
Date: 2001-07-13 08:19:59
Message-ID: 11C1E6749A55D411A9670001FA687963368384@sdexcsrv1.f000.d0188.sd.spardat.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Zeugswetter Andreas SB 2001-07-13 08:36:13 AW: Re: SOMAXCONN (was Re: Solaris source code)
Previous Message Hiroshi Inoue 2001-07-13 02:16:55 Re: Rule recompilation