pg_statistics
Started by Nonameabout 24 years ago2 messagesgeneral
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
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