Re: how to find which tables required indexes in postgresql

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: how to find which tables required indexes in postgresql
Date: 2013-04-10 12:43:48
Message-ID: kk3mnt$ama$1@ger.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Zahid Quadri, 10.04.2013 13:31:
> hi,,
>
> please suggest if there is any way which i can find which tables need indexes in postgresql.
>

Tables don't need indexes. Queries do. You will need to show us the queries in question (e.g. those that are slow) in order to decide which index is helpful.

Thomas

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Condor 2013-04-10 13:03:45 How to convert US date format to European date format ?
Previous Message Atri Sharma 2013-04-10 12:38:08 Re: how to find which tables required indexes in postgresql