Postgres Pro
Downloads
Home   >   mailing lists

Re: Question about Foreign key constraint causes "costly sequential scans"? - Mailing list pgsql-general

From Tom Lane
Subject Re: Question about Foreign key constraint causes "costly sequential scans"?
Date
Msg-id 2467.1124809028@sss.pgh.pa.us
Whole thread Raw
In response to Question about Foreign key constraint causes "costly sequential scans"?  (Emi Lu <emilu@cs.concordia.ca>)
List pgsql-general
Tree view 
Emi Lu <emilu@cs.concordia.ca> writes:
> But I got a warning msg from postgresql as:
>    foreign key constraint "Aclo3_fk" will require costly sequential scans

Try to make the referencing and referenced columns the same datatype.

            regards, tom lane

pgsql-general by date:

Previous
From: "Rodrigo Africani"
Date:
Subject: Import File
Next
From: Matt Miller
Date:
Subject: Re: Question about Foreign key constraint causes "costly