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: 8053.1079988963@sss.pgh.pa.us (view raw or flat)
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
recently?

			regards, tom lane

In response to

Responses

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-2014 The PostgreSQL Global Development Group