Обсуждение: pg_statistics

Поиск
Список
Период
Сортировка

pg_statistics

От
f2160528@est.fib.upc.es
Дата:
Hi,

In which view in the postgre sql catalog
exists the maximum and the minimum value from
an attribute from a relation???

Is it pg_statistics??

Every time i do an insert in my database this
view gets up to date??

Can anyone help me??

Thanks in advance.

David.

Re: pg_statistics

От
Thomas Lockhart
Дата:
> In which view in the postgre sql catalog
> exists the maximum and the minimum value from
> an attribute from a relation???
> Is it pg_statistics??

No, that is just approximate statistics to help the optimizer.

> Every time i do an insert in my database this
> view gets up to date??

No, the original table is scanned when you call the max() or min()
aggregate functions.

hth

                    - Thomas