Re: Vacuum only with 20% old tuples - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Vacuum only with 20% old tuples
Date
Msg-id 200007121540.LAA24061@candle.pha.pa.us
Whole thread Raw
In response to Re: Vacuum only with 20% old tuples  (The Hermit Hacker <scrappy@hub.org>)
Responses Re: Vacuum only with 20% old tuples  (The Hermit Hacker <scrappy@hub.org>)
List 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,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: Zeugswetter Andreas SB
Date:
Subject: AW: fmgr changes not yet ported to AIX
Next
From: Zeugswetter Andreas SB
Date:
Subject: AW: 7.0.2 issues / Geocrawler