pg_statistics

Started by Nonameabout 24 years ago2 messagesgeneral
Jump to latest
#1Noname
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.

#2Thomas Lockhart
lockhart@fourpalms.org
In reply to: Noname (#1)
Re: pg_statistics

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