Postgres Pro
Downloads
Home   >   mailing lists

Re: Slow Foreign Key - Mailing list pgsql-admin

From Tom Lane
Subject Re: Slow Foreign Key
Date
Msg-id 8053.1079988963@sss.pgh.pa.us
Whole thread Raw
In response to Slow Foreign Key  (Ricardo Vaz Mannrich <rvm_l1@silcom.com.br>)
Responses Re: Slow Foreign Key  (Sam Barnett-Cormack <s.barnett-cormack@lancaster.ac.uk>)
List pgsql-admin
Tree view 
Ricardo Vaz Mannrich <rvm_l1@silcom.com.br> writes:
> Is FOREIGN KEY so slow like that?

Not normally.  Have you checked that the referencing and referenced
columns are of the same datatype?  Have you done ANALYZE on both tables
recently?

            regards, tom lane

pgsql-admin by date:

Previous
From: Ricardo Vaz Mannrich
Date:
Subject: Slow Foreign Key
Next
From: "Subbiah, Stalin"
Date:
Subject: Databases Vs. Schemas