something to suggest indexes - Mailing list pgsql-general

From John
Subject something to suggest indexes
Date
Msg-id 200907161011.34848.jfabiani@yolo.com
Whole thread Raw
Responses Re: something to suggest indexes
List pgsql-general
Hi,

Is there something built-in to Postgres that would suggest what indexes I
might add to improve performance?  I created my required tables (they only
contain small amounts of test data) and the performance is great.  But as the
data starts growing I'm betting that creating a few indexes will be needed.

In the past I just started playing with explain using a hit and miss way of
doing it.

If there is nothing in Postgres does anyone have any suggestions?

John

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Problems with 8.4, FLOAT8PASSBYVAL and x86_64 GNU/Linux
Next
From: CG
Date:
Subject: Re: best practice transitioning from one datatype to another