On Mon, 22 Mar 2004, Tom Lane wrote:
> 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?
Other question that seems, from my experience, to be relevant - are the
referenced/referencing columns indexed?
--
Sam Barnett-Cormack
Software Developer | Student of Physics & Maths
UK Mirror Service (http://www.mirror.ac.uk) | Lancaster University
