Thread: data statistic functions

Hullo List,

What does Postgres offer in terms of statistics support (not the
statistics about the database, but functions to operate on the data).

I know there are simple things like AVG, COUNT, MAX, and MIN, but what else?

I'm not sure where to begin looking, other than a cursory inspection of
http://www.postgresql.org/docs/8.3/static/functions.html . . .

On a side note, I also noted that I couldn't immediately spot AVG, MAX,
or MIN in the output of \df.

Thanks,

Kevin

On Tue, 23 Oct 2007 16:43:04 -0400
Kevin Hunter <hunteke@earlham.edu> wrote:

> Hullo List,
>
> What does Postgres offer in terms of statistics support (not the
> statistics about the database, but functions to operate on the data).
>
> I know there are simple things like AVG, COUNT, MAX, and MIN, but
> what else?
>
> I'm not sure where to begin looking, other than a cursory inspection
> of http://www.postgresql.org/docs/8.3/static/functions.html . . .
>
> On a side note, I also noted that I couldn't immediately spot AVG,
> MAX, or MIN in the output of \df.

http://www.postgresql.org/docs/8.2/static/functions-aggregate.html

Sincerely,

Joshua D. Drake



>
> Thanks,
>
> Kevin
>
> ---------------------------(end of
> broadcast)--------------------------- TIP 2: Don't 'kill -9' the
> postmaster
>


--

      === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564   24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997  http://www.commandprompt.com/
            UNIQUE NOT NULL
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/

On Oct 23, 2007, at 1:43 PM, Kevin Hunter wrote:

> Hullo List,
>
> What does Postgres offer in terms of statistics support (not the
> statistics about the database, but functions to operate on the data).
>
> I know there are simple things like AVG, COUNT, MAX, and MIN, but
> what else?
>
> I'm not sure where to begin looking, other than a cursory
> inspection of
> http://www.postgresql.org/docs/8.3/static/functions.html . . .

Take a look under "Aggregate Functions" ( http://www.postgresql.org/
docs/8.3/static/functions-aggregate.html ). There's probably some
interesting stuff if you look at PL/R too ( http://pgfoundry.org/
projects/plr/ ).

Cheers,
   Steve

At 4:53p -0400 on 23 Oct 2007, Steve Atkins wrote:
> There's probably some interesting stuff if you look at PL/R too (
> http://pgfoundry.org/projects/plr/ ).

PL/R . . . that looks promising.  Thanks.

Kevin

Kevin Hunter <hunteke@earlham.edu> writes:
> On a side note, I also noted that I couldn't immediately spot AVG, MAX,
> or MIN in the output of \df.

\df explicitly excludes aggregate functions.  Try \da.

            regards, tom lane