Re: how to find which tables required indexes in postgresql

[Atri Sharma <atri.jiit@xxxxxxxxx>]

Sent from my iPad

On 10-Apr-2013, at 17:01, Zahid Quadri <zahid.quadri@xxxxxxxxxxxxxxxxxx> 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