From: | Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec> |
---|---|
To: | jmurtari(at)thebook(dot)com |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Patch set under development to add usage reporting. |
Date: | 2009-10-31 05:11:24 |
Message-ID: | 3073cc9b0910302211l65ac83a2hd3a6eac56b90ca67@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | David Fetter | 2009-10-31 06:54:24 | Re: half OOT, plv8js group created ^^ |
Previous Message | Tom Lane | 2009-10-31 04:25:25 | Re: Making hash indexes worthwhile |