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

From Bruce Momjian
Subject Re: Postgresql backend to perform vacuum automatically
Date
Msg-id 200203050153.g251rqW08584@candle.pha.pa.us
Whole thread Raw
In response to Postgresql backend to perform vacuum automatically  ("Nicolas Bazin" <nbazin@ingenico.com.au>)
Responses Re: Postgresql backend to perform vacuum automatically  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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
backendto keep track of the number of update performed on a database and after a certain threshold start a vacuum in a
separateprocess 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@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: Barry Lind
Date:
Subject: Re: JDBC: java.sql.SQLException: results returned
Next
From: "Rod Taylor"
Date:
Subject: Dependencies with pg_depends