Thread: pg_statistics

pg_statistics

From
f2160528@est.fib.upc.es
Date:
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

From
Thomas Lockhart
Date:
> 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