Re: Trying to understand VACUUM VERBOSE

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Trying to understand VACUUM VERBOSE
Дата
Msg-id 1863.974186911@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Trying to understand VACUUM VERBOSE  ("Kevin O'Gorman" <kogorman@pacbell.net>)
Список pgsql-general
"Kevin O'Gorman" <kogorman@pacbell.net> writes:
> I've got 33150 rows which the EXPLAIN said at top level would be
> 80-byte rows.  VACUUM indicates 488 pages.  Does this compute?

Keep in mind that EXPLAIN's estimates of average row width are almost,
but not quite, entirely bogus.  I'm actually quite surprised that your
arithmetic produced a number as close to 8K as it did.

We need to start keeping stats about the average width of variable-
length columns; until we do, EXPLAIN can't possibly produce row width
estimates that are at all accurate.

            regards, tom lane

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

Предыдущее
От: hubert depesz lubaczewski
Дата:
Сообщение: Re: 7.0.3 RPMs?
Следующее
От: Marcos
Дата:
Сообщение: moving throw the resultset