Vacuum only with 20% old tuples

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Vacuum only with 20% old tuples
Дата
Msg-id 200007120040.UAA27940@candle.pha.pa.us
обсуждение исходный текст
Ответы Re: Vacuum only with 20% old tuples  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
I suggest that we change vacuum to only move remove tuples if there is
more than 20% expired tuples.

When we do vacuum, we drop all indexes and recreate them.  

This fixes the complaint about vacuum slowness when there are many
expired rows in the table.  We know this is causes by excessive index
updates.  It allows indexes to shrink (Jan pointed this out to me.)  And
it fixes the TOAST problem with TOAST values in indexes.

--  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 по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: Templates
Следующее
От: Tim Perdue
Дата:
Сообщение: 7.0.2 issues / Geocrawler