"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote in message
news:20904(dot)1251397138(at)sss(dot)pgh(dot)pa(dot)us(dot)(dot)(dot)
> Steve T <steve(at)retsol(dot)co(dot)uk> writes:
>> PS Is there a reason that PostgreSql doesn't automatically create the
>> foreign key indexes?
>
> Sometimes you don't need/want them, or they might already exist because
> of other constraints you made. It is a bit of a gotcha for newbies,
> but we've concluded that forcing such indexes to be made would be a
> net loss.
>
I would like to run a utility to identify any missing indexes for
foreign-keys so I don't suffer the same faith.
Just wondering if there is something built-in PostgreSQL or pgAdmin already?
Or should I follow these blogs/posts:
http://mlawire.blogspot.com/2009/08/postgresql-indexes-on-foreign-keys.html
http://archives.postgresql.org/pgsql-general/2008-12/msg00880.php
Thanks,
Eric