Re: Postgresql backend to perform vacuum automatically - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Postgresql backend to perform vacuum automatically
Date
Msg-id 23021.1015431112@sss.pgh.pa.us
Whole thread Raw
In response to Re: Postgresql backend to perform vacuum automatically  ("Zeugswetter Andreas SB SD" <ZeugswetterA@spardat.at>)
Responses Re: Postgresql backend to perform vacuum automatically  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
"Zeugswetter Andreas SB SD" <ZeugswetterA@spardat.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


pgsql-hackers by date:

Previous
From: Thomas Lockhart
Date:
Subject: Mandrake RPMs rebuilt
Next
From: Turbo Fredriksson
Date:
Subject: Re: Drop in performance for each INSERT/DELETE combo