Re: Postgresql backend to perform vacuum automatically

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: 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-05 05:33:34
Message-ID: 12988.1015306414@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> Nicolas Bazin wrote:
> From what I read in the recent exchanges in the PostgreSQL vs ORACLE thread it would seem a good idea for the backend to keep track of the number of update performed on a database and after a certain threshold start a vacuum in a separate process by itself.
>> Any comments?

> Yes, makes sense to me, especially now that we have a nolocking vacuum.
> Tom, do you have any ideas on this?

There's a TODO item about this already.

* Provide automatic scheduling of background vacuum (Tom)

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Christopher Kings-Lynne 2002-03-05 06:03:52 Re: Postgresql backend to perform vacuum automatically
Previous Message Bruce Momjian 2002-03-05 04:11:03 Re: Problem in ResultSet#getTimestamp() of 7.2b4