Re: Analyze tool? - Mailing list pgsql-general

From ioguix
Subject Re: Analyze tool?
Date
Msg-id 4CA5BF3D.2060400@free.fr
Whole thread Raw
In response to Analyze tool?  (Bjørn T Johansen <btj@havleik.no>)
List 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
SQLstatements 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-----

pgsql-general by date:

Previous
From: Thom Brown
Date:
Subject: Multiple table scans to analyze multiple indexes
Next
From: Frank Church
Date:
Subject: How many databases can PostgreSQL open at a time?