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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-admin by date

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