Re: how to find which tables required indexes in postgresql

Поиск
Список
Период
Сортировка
От Atri Sharma
Тема Re: how to find which tables required indexes in postgresql
Дата
Msg-id B9DA39F0-5BC2-417E-A28E-FD0882C7827C@gmail.com
обсуждение исходный текст
Ответ на how to find which tables required indexes in postgresql  (Zahid Quadri <zahid.quadri@cloverinfotech.com>)
Список pgsql-general
Дерево обсуждения


Sent from my iPad

On 10-Apr-2013, at 17:01, Zahid Quadri <zahid.quadri@cloverinfotech.com> wrote:

hi,,

please suggest if there is any way which i can find which tables need indexes in postgresql.







If the table under consideration has lots of data,and queries on it are very slow,you could consider adding an index to column(s) of that table.

Note,however,making excessive indexes may be harmful as well,so please be judicious while making them.

Regards,

Atri



В списке pgsql-general по дате отправления:

Предыдущее
От: Zahid Quadri
Дата:
Сообщение: how to find which tables required indexes in postgresql
Следующее
От: Thomas Kellerer
Дата:
Сообщение: Re: how to find which tables required indexes in postgresql