Re: Fix pgstatindex using for large indexes - Mailing list pgsql-patches

From Tom Lane
Subject Re: Fix pgstatindex using for large indexes
Date
Msg-id 12407.1203615534@sss.pgh.pa.us
Whole thread Raw
In response to Fix pgstatindex using for large indexes  (Tatsuhito Kasahara <kasahara.tatsuhito@oss.ntt.co.jp>)
Responses 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>)
List 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 by date:

Previous
From: Zdenek Kotala
Date:
Subject: fix in --help output
Next
From: Zdenek Kotala
Date:
Subject: --describe-config crashes