Re: Indexing foreign keys

Yes, I had not only done a "vacuum full analyze" on the PG db once I
stuffed it, but I also compared that with an IFX db that I had run
"update statistics high" on.  Things are much better with the FK indexes.

Did the docs say to index those FK fields (is that standard in the DB
industry?), or was I just spoiled by IFX doing it for me?  ;)

Thanks!



Chad Thompson wrote:
> Make sure that you've run a vacuum and an analyze.  There is also a
> performance hit if the types of the fields or values are different. ie int
> to int8

--
Matt Mello