Postgres Pro
Downloads
Home   >   mailing lists

Re: 7.4 - FK constraint performance - Mailing list pgsql-sql

From ow
Subject Re: 7.4 - FK constraint performance
Date
Msg-id 20040213012253.64419.qmail@web60807.mail.yahoo.com
Whole thread Raw
In response to 7.4 - FK constraint performance  (ow <oneway_111@yahoo.com>)
Responses Re: 7.4 - FK constraint performance
List pgsql-sql
Tree view 
--- Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Can't see how we optimize your case without pessimizing more-common cases.

My case appears to be pretty common, i.e. 1 small and 1 large table with RI
constraint between them. In order to delete a record from the small table, the
large table must not have records that are dependent on the deleted row.

I think other RDBMSs simply use preset value instead of partial table scan when
there's not enough stat info. Might be a better way.

Thanks



__________________________________
Do you Yahoo!?
Yahoo! Finance: Get your refund fast by filing online.
http://taxes.yahoo.com/filing.html

pgsql-sql by date:

Previous
From: Joe Conway
Date:
Subject: Re: array_lower /array_prepend doubt
Next
From: Tom Lane
Date:
Subject: Re: 7.4 - FK constraint performance