Re: Vacuum only with 20% old tuples
Bruce Momjian <pgman@candle.pha.pa.us>
From: Bruce Momjian <pgman@candle.pha.pa.us>
To: The Hermit Hacker <scrappy@hub.org>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2000-07-12T15:40:18Z
Lists: pgsql-hackers
> > I do not see what your 20% idea has to do with this, though, nor > > why it's a good idea. If I've told the thing to vacuum I think > > it should vacuum. 20% of a big table could be a lot of megabytes, > > and I don't want some arbitrary decision in the code about whether > > I can reclaim that space or not. > > I wouldn't mind seeing some automagic vacuum happen *if* >20% expired > ... but don't understand the limit when I tell it to vacuum either ... I am confused by your comment. -- 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, Pennsylvania 19026