Postgres Pro
Downloads
Home   >   mailing lists

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

From Thomas Kellerer
Subject Re: how to find which tables required indexes in postgresql
Date
Msg-id kk3mnt$ama$1@ger.gmane.org
Whole thread Raw
In response to how to find which tables required indexes in postgresql  (Zahid Quadri <zahid.quadri@cloverinfotech.com>)
Responses Re: how to find which tables required indexes in postgresql
List pgsql-general
Tree view 
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
orderto decide which index is helpful. 

Thomas

pgsql-general by date:

Previous
From: Atri Sharma
Date:
Subject: Re: how to find which tables required indexes in postgresql
Next
From: Condor
Date:
Subject: How to convert US date format to European date format ?