Re: Analyze tool?

Поиск
Список
Период
Сортировка
От ioguix
Тема Re: Analyze tool?
Дата
Msg-id 4CA5BF3D.2060400@free.fr
обсуждение исходный текст
Ответ на Analyze tool?  (Bjørn T Johansen <btj@havleik.no>)
Список 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 по дате отправления:

Предыдущее
От: Thom Brown
Дата:
Сообщение: Multiple table scans to analyze multiple indexes
Следующее
От: Frank Church
Дата:
Сообщение: How many databases can PostgreSQL open at a time?