Re: WARNING: foreign key constraint will require costly sequential scans during pg_restore

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: cgg007(at)yahoo(dot)com
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: WARNING: foreign key constraint will require costly sequential scans during pg_restore
Date: 2006-02-22 15:30:37
Message-ID: 11982.1140622237@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

CG <cgg007(at)yahoo(dot)com> writes:
> pg_restore: WARNING: foreign key constraint "luuid_fkey" will require costly
> sequential scans
> DETAIL: Key columns "luuid" and "luuid" are of different types:
> public.uniqueidentifier and public.uniqueidentifier.

That seems a bit odd. Would you provide a test case?

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Andy Shellam 2006-02-22 16:26:49 WAL recovery
Previous Message CG 2006-02-22 15:26:11 WARNING: foreign key constraint will require costly sequential scans during pg_restore