Postgres Pro
Downloads
Home   >   mailing lists

Re: how to find which tables required indexes in postgresql - Mailing list pgsql-general

From Atri Sharma
Subject Re: how to find which tables required indexes in postgresql
Date
Msg-id B9DA39F0-5BC2-417E-A28E-FD0882C7827C@gmail.com
Whole thread Raw
In response to how to find which tables required indexes in postgresql  (Zahid Quadri <zahid.quadri@cloverinfotech.com>)
List pgsql-general
Tree view


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 by date:

Previous
From: Zahid Quadri
Date:
Subject: how to find which tables required indexes in postgresql
Next
From: Thomas Kellerer
Date:
Subject: Re: how to find which tables required indexes in postgresql