Re: pg_statistics

From: Thomas Lockhart <lockhart(at)fourpalms(dot)org>
To: f2160528(at)est(dot)fib(dot)upc(dot)es
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_statistics
Date: 2002-02-20 14:05:19
Message-ID: 3C73AD1F.9C656646@fourpalms.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-02-20 14:56:45 Re: upgrade to 7.2 & pgdumpall
Previous Message f2160528 2002-02-20 12:11:01 pg_statistics