Skip site navigation (1) Skip section navigation (2)

Re: Slow Foreign Key

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ricardo Vaz Mannrich <rvm_l1(at)silcom(dot)com(dot)br>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Slow Foreign Key
Date: 2004-03-22 20:56:03
Message-ID: (view raw or whole thread)
Lists: pgsql-admin
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

			regards, tom lane

In response to


pgsql-admin by date

Next:From: Subbiah, StalinDate: 2004-03-22 21:00:21
Subject: Databases Vs. Schemas
Previous:From: Ricardo Vaz MannrichDate: 2004-03-22 18:24:58
Subject: Slow Foreign Key

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group