8.x VACUUM overestimates reltuples?

Поиск
Список
Период
Сортировка
От Michael Fuhr
Тема 8.x VACUUM overestimates reltuples?
Дата
Msg-id 20050212060634.GA72853@winnie.fuhr.org
обсуждение исходный текст
Ответы Re: 8.x VACUUM overestimates reltuples?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Is VACUUM in 8.x supposed to be overestimating reltuples by 50% of
the number of dead tuples?

CREATE TABLE foo (x integer);
INSERT INTO foo SELECT * FROM generate_series(1, 1000);
UPDATE foo SET x = x;
UPDATE foo SET x = x;
UPDATE foo SET x = x;
VACUUM foo;
SELECT relpages, reltuples FROM pg_class WHERE relname = 'foo';relpages | reltuples 
----------+-----------      22 |      2500

Another VACUUM at this point brings reltuples back to the actual
number of rows in the table:

VACUUM foo;
SELECT relpages, reltuples FROM pg_class WHERE relname = 'foo';relpages | reltuples 
----------+-----------      22 |      1000

Is this intentional?

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [GENERAL] WARNING: could not remove database directory
Следующее
От: Tom Lane
Дата:
Сообщение: Re: 8.x VACUUM overestimates reltuples?