doe sit include monitoring replicas ?
Cheers,
Ben-
On Fri, Oct 7, 2011 at 3:01 PM, Fernando Hevia wrote:
> pgwatch might also be worth taking a look
> at: http://www.cybertec.at/en/postgresql_products/pgwatch-cybertec-enterprise-postgresql-monitor
> Fernando.-
> On Fri, Sep 30, 2011 at 18:29,
pgwatch might also be worth taking a look at:
http://www.cybertec.at/en/postgresql_products/pgwatch-cybertec-enterprise-postgresql-monitor
Fernando.-
On Fri, Sep 30, 2011 at 18:29, Bobby Dewitt wrote:
> EnterpriseDB now has Postgres Enterprise Manager
> (
> http://enterprisedb.com/products-serv
Title: Documento senza titolo
Il 07/10/2011 12:24, Guillaume Cottenceau ha scritto:
Giovanni Mancuso writes:
select count(*) from dm_object_perm;
count
--
38'928'077
(1 row)
[...]
If i run "explain analyze select *
2011/10/7 Giovanni Mancuso
> Hi,
>
> I have a problem with my postgres 8.2.
>
> I Have an application that write ojbect (file, folder, ecc.) and another
> table that have account. This to tables are likend eith another tablenthat
> have a permissions foreach objects + accounts.
>
> My structure
Do you need left join ?
Can you further normalize the tables? (to lower the I/O)
Can you upgrade to at least 8.3 ? It has huuge performance
improvements over 8.3.
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgre
Giovanni Mancuso writes:
> select count(*) from dm_object_perm;
> count
> --
> 38'928'077
> (1 row)
[...]
> If i run "explain analyze select * from dm_object_perm;" it goes on for many
> hours.
Almost 39 million records is not small, especially if you run on
poor hardware[1], poor
Title: Documento senza titolo
Hi,
I have a problem with my postgres 8.2.
I Have an application that write ojbect (file, folder, ecc.) and
another table that have account. This to tables are likend eith
another tablenthat have a permissions foreach objects + acc
