--- Andreas Pflug <pgadmin@pse-consulting.de> 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.phphttp://archives.postgresql.org/pgsql-admin/2003-11/msg00319.php
__________________________________
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/
