On Mon, 22 Mar 2004, Tom Lane wrote: > Ricardo Vaz Mannrich <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster