On Mon, 22 Mar 2004, Tom Lane wrote:
> Ricardo Vaz Mannrich <rvm_l1(at)silcom(dot)com(dot)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
Other question that seems, from my experience, to be relevant - are the
referenced/referencing columns indexed?
Software Developer | Student of Physics & Maths
UK Mirror Service (http://www.mirror.ac.uk) | Lancaster University
In response to
pgsql-admin by date
|Next:||From: Tom Lane||Date: 2004-03-22 22:04:50|
|Subject: Re: Databases Vs. Schemas |
|Previous:||From: Subbiah, Stalin||Date: 2004-03-22 21:30:24|
|Subject: Databases Vs. Schemas|