Re: Fix pgstatindex using for large indexes

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Fix pgstatindex using for large indexes
Дата
Msg-id 12407.1203615534@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Fix pgstatindex using for large indexes  (Tatsuhito Kasahara <kasahara.tatsuhito@oss.ntt.co.jp>)
Ответы Re: Fix pgstatindex using for large indexes  (Tatsuhito Kasahara <kasahara.tatsuhito@oss.ntt.co.jp>)
Re: Fix pgstatindex using for large indexes  (Zdenek Kotala <Zdenek.Kotala@Sun.COM>)
Список pgsql-patches
Tatsuhito Kasahara <kasahara.tatsuhito@oss.ntt.co.jp> writes:
> In pgstatindex.c and pgstattuple.sql, some variables are defined with
> int type. So when we try to get informations about a large index by using
> pgstatindex, we get strange value of size and density.
> Because the values exceed int-max.
> ...
> I think that max_avail and free_space should be uint64.

Most places where we've dealt with this before, we use double, which is
guaranteed to be available whereas uint64 is not ...

            regards, tom lane

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

Предыдущее
От: Zdenek Kotala
Дата:
Сообщение: fix in --help output
Следующее
От: Zdenek Kotala
Дата:
Сообщение: --describe-config crashes