By the way, I presume foreign key indices are used to check for referential integrity on insert. Can the query planner also use then somehow?
It can use them the same way it can use any other index.
Hmm, I guess I thought that "foreign key indices" were some special kind of index. For instance, I thought that Postgresql might effectively pre-compute part of the information it needed to do a join on the two relevant columns.
I'm guessing now that we're just talking about a regular index on a column that happens to have a foreign key reference to another column. Is that the case?
Thanks.
- John D. Burger MITRE
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
