Re: Postgresql backend to perform vacuum automatically

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Nicolas Bazin <nbazin(at)ingenico(dot)com(dot)au>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Postgresql backend to perform vacuum automatically
Date: 2002-03-05 01:53:52
Message-ID: 200203050153.g251rqW08584@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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?

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Rod Taylor 2002-03-05 02:16:43 Dependencies with pg_depends
Previous Message Barry Lind 2002-03-05 01:32:46 Re: [HACKERS] JDBC: java.sql.SQLException: results returned