[DOCS] PostgreSQL 7.4 Documentation - perform.sgml

[Halley Pacheco de Oliveira]

In file perform.sgml is written:

The amount of information stored in
pg_statistic,
in particular the maximum number of entries in the
most_common_vals and
histogram_bounds
arrays for each column, can be set on a ...

But most_common_vals and histogram_bounds are columns
from the view pg_stats and not from the table
pg_statistic.

Halley


__

Yahoo! Mail - O melhor e-mail do Brasil! Abra sua conta agora:
http://br.yahoo.com/info/mail.html

---(end of broadcast)---
TIP 6: Have you searched our list archives?

   http://archives.postgresql.org

Re: [DOCS] PostgreSQL 7.4 Documentation - perform.sgml

[Tom Lane]

=?iso-8859-1?q?Halley=20Pacheco=20de=20Oliveira?= <[EMAIL PROTECTED]> writes:
> In file perform.sgml is written:
> The amount of information stored in
> pg_statistic,
> in particular the maximum number of entries in the
> most_common_vals and
> histogram_bounds
> arrays for each column, can be set on a ...

> But most_common_vals and histogram_bounds are columns
> from the view pg_stats and not from the table
> pg_statistic.

True, but being pedantically correct would obscure the sentence
completely, I fear.  You'd need some sort of arm-waving about
"the slot numbers and values entries corresponding to statistic kinds
STATISTIC_KIND_MCV and STATISTIC_KIND_HISTOGRAM", or something like
that :-(.  That might be appropriate in catalogs.sgml but I think it
will just confuse the readers of perform.sgml.

regards, tom lane

---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
  joining column's datatypes do not match