Re: pg_statistics - Mailing list pgsql-general

From Thomas Lockhart
Subject Re: pg_statistics
Date
Msg-id 3C73AD1F.9C656646@fourpalms.org
Whole thread Raw
In response to pg_statistics  (f2160528@est.fib.upc.es)
List 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 by date:

Previous
From: "Art Nicewick"
Date:
Subject: Re: Reporting Tools (OLAP)
Next
From: Tom Lane
Date:
Subject: Re: upgrade to 7.2 & pgdumpall