--- Andreas Pflug <[EMAIL PROTECTED]> wrote: > Stephan Szabo wrote: > > > > > > >IIRC, he was. I think the thing causing the difference between his times > >and the ones we saw typically when doing the tests was that he didn't have > >an index on the fktable's referencing column. > > > > > > A common mistake, can't count how often I created this one...
Wrong. It's a mistake to think that you always HAVE to have an index on FK column. See the links below for more details: http://archives.postgresql.org/pgsql-admin/2003-11/msg00317.php http://archives.postgresql.org/pgsql-admin/2003-11/msg00319.php __________________________________ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
