Re: how to find which tables required indexes in postgresql

From: Atri Sharma <atri(dot)jiit(at)gmail(dot)com>
To: Zahid Quadri <zahid(dot)quadri(at)cloverinfotech(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: how to find which tables required indexes in postgresql
Date: 2013-04-10 12:38:08
Message-ID: B9DA39F0-5BC2-417E-A28E-FD0882C7827C@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Sent from my iPad

On 10-Apr-2013, at 17:01, Zahid Quadri <zahid(dot)quadri(at)cloverinfotech(dot)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
>
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Kellerer 2013-04-10 12:43:48 Re: how to find which tables required indexes in postgresql
Previous Message Zahid Quadri 2013-04-10 11:31:38 how to find which tables required indexes in postgresql