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