Re: pg_statistics

Поиск
Список
Период
Сортировка
От Thomas Lockhart
Тема Re: pg_statistics
Дата
Msg-id 3C73AD1F.9C656646@fourpalms.org
обсуждение исходный текст
Ответ на pg_statistics  (f2160528@est.fib.upc.es)
Список pgsql-general
> 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

В списке pgsql-general по дате отправления: