On Fri, Oct 30, 2009 at 11:02 AM, John Murtari <jmurtari@thebook.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