Re: Vacuum only with 20% old tuples

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Vacuum only with 20% old tuples
Дата
Msg-id 200007121540.LAA24061@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: Vacuum only with 20% old tuples  (The Hermit Hacker <scrappy@hub.org>)
Ответы Re: Vacuum only with 20% old tuples  (The Hermit Hacker <scrappy@hub.org>)
Список 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 по дате отправления:

Предыдущее
От: Zeugswetter Andreas SB
Дата:
Сообщение: AW: fmgr changes not yet ported to AIX
Следующее
От: Zeugswetter Andreas SB
Дата:
Сообщение: AW: 7.0.2 issues / Geocrawler