Re: pg_stats.avg_width differs by a factor of 4 on different machines

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_stats.avg_width differs by a factor of 4 on different machines
Дата
Msg-id 29077.1243902648@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: pg_stats.avg_width differs by a factor of 4 on different machines  (Craig de Stigter <craig.destigter@koordinates.com>)
Список pgsql-general
Дерево обсуждения 
Craig de Stigter <craig.destigter@koordinates.com> writes:
> Does anyone have any idea why these numbers would be 4 times as big in
> Postgres 8.3.7 ?

It still doesn't make any sense to me that you're getting values larger
than the BLCKSZ.  If you look into where that's coming from you might
get a clue what's up with the version difference.

            regards, tom lane

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

Предыдущее
От: Craig de Stigter
Дата:
Сообщение: Re: pg_stats.avg_width differs by a factor of 4 on different machines
Следующее
От: Andrew Smith
Дата:
Сообщение: Re: newbie table design question