Re: Patch set under development to add usage reporting.

On Fri, Oct 30, 2009 at 11:02 AM, John Murtari <jmurtari(at)thebook(dot)com> wrote:
>
>     The project web site has a lot of info, but here is a quick
> example of what it does:
>
> thebook=#  show statistics * from db history;
>   db    |    minutes     | Questions | Connections | Com_delete
> ---------+----------------+-----------+-------------+------------
>  thebook | 10/26/09 09:45 | 1         | 0           | 0
>  thebook | 10/26/09 09:44 | 8         | 1           | 6
>  thebook | 10/26/09 09:43 | 0         | 1           | 0
>

seems interesting, the syntax needs a little work but...

>     We now have a basic patch set that works and is basically
> stable (not recommended for production servers!).  We've dedicated
> a page at our web site and it hopefully has answers to most of
> your questions, and also has the patch set for download.  These
> are for 7.4.19 - the version included with RHEL 4.
>

oops... we don't add new features to old branches just bug fixes...
you need to make that patchset work in 8.5 (currently in development)

> http://www.ExtSQL.com/postgres_notes.php
>
>     We certainly welcome your feedback and thoughts on this.
> There is still some hard work to be done.  We have an INFORMATION
> SCHEMA implementation for MySQL 5.x, but not yet for PostgreSQL.
>

we have an information schema since 7.4
(http://www.postgresql.org/docs/7.4/static/information-schema.html)

--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157