Re: Postgresql backend to perform vacuum automatically

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Zeugswetter Andreas SB SD" <ZeugswetterA(at)spardat(dot)at>
Cc: "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us>, "mlw" <markw(at)mohawksoft(dot)com>, "Nicolas Bazin" <nbazin(at)ingenico(dot)com(dot)au>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Postgresql backend to perform vacuum automatically
Date: 2002-03-06 16:11:52
Message-ID: 23021.1015431112@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Zeugswetter Andreas SB SD" <ZeugswetterA(at)spardat(dot)at> writes:
> I still think, that for best results the vacuums should happen continuously
> for single pages based on a hook in wal or the buffer manager.

Not possible unless you are willing to have SELECTs grab much stronger
locks than they do now (viz, the same kind of lock that VACUUM does).

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Turbo Fredriksson 2002-03-06 16:18:15 Re: Postgresql backend to perform vacuum automatically
Previous Message Tom Lane 2002-03-06 16:08:46 Re: Weird WAL numbering