Re: pg_class -> reltuples?

Neil Conway wrote:
> Hi all,
>
> Is there a reason why the reltuples column of pg_class is stored as a
> "real", rather than one of the integer data types? Are there any
> situations in which there will be a non-integer value stored in this
> column?

That is an excellent question. I assume it is related to having > 4
billion rows, but we have int8 for that. The value is used mostly by
the optimizer, which does most of its calcultions using float8 (real),
so that may be why.

> P.S. I tried to search the archives, but archives.postgresql.org is so
> slow, it's basically unusable. So my apologies if this has already been
> discussed...

Yes, it is hampering me from researching some of these patches too, and
fts is completely down. If I could just get a web page of all the
threads (forget searching), I would be happy. The archives site contents
hasn't been updated since Feb 28.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026