Re: Patch set under development to add usage reporting.

Jaime,

> > 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...
>
> > 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)

If you have time to give us any feedback on syntax/output
it is welcome. Regarding INFORMATION SCHEMA, we saw it in 7.4.19 but
are really struggling with the implementation. In MySQL 5.0.x, the
schema tables are created/populated when asked for as temporary
tables. There were some built in routines to create the schema tables
when needed. It was fairly easy for us to take data from our
structures and fill the tables.

My first scan on PosgreSQL gave me the impression the tables
have more stability and are updated on an ongoing basis? If you have
any pointers to schema table creation that would be great!

Best regards!
--
John
____________________________________________________________________
John Murtari Software Workshop Inc.
jmurtari(at)thebook(dot)com "software that fits!" (TM)
(315) 944-0999 (x-211) http://www.SoftwareWorkshop.com/