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@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026