Re: Analyze tool?

From: ioguix <ioguix(at)free(dot)fr>
To: Bjørn T Johansen <btj(at)havleik(dot)no>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Analyze tool?
Date: 2010-10-01 11:00:13
Message-ID: 4CA5BF3D.2060400@free.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Le 01/10/2010 11:53, Bjørn T Johansen a écrit :
> We are using both DB2 and PostgreSQL at work and DB2 has a nice tool, i5 Navigator, where one can enable logging of SQL statements and then it will
> recommed indexes that should/could be created to increase speed...
> Does there exist a similar tool for PostgreSQL?

There some work about this kind of feature but nothing officially
released AFAIK.

See http://www.pgcon.org/2010/schedule/events/233.en.html

>
>
> Regards,
>
> BTJ
>

- --
Jehan-Guillaume (ioguix) de Rorthais
www.dalibo.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAkylvzcACgkQxWGfaAgowiIDKgCfXCvYxRC5Dmpbj/VAXmBJ8JxM
wb8Aniq3Aho1WlMZbOA0/sdaWEcSHGcg
=dS1n
-----END PGP SIGNATURE-----

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bjørn T Johansen 2010-10-01 11:18:50 Re: Analyze tool?
Previous Message Frank Church 2010-10-01 10:51:34 How many databases can PostgreSQL open at a time?