Re: 7.4 - FK constraint performance

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: ow <oneway_111(at)yahoo(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: 7.4 - FK constraint performance
Date: 2004-02-13 01:10:36
Message-ID: 25808.1076634636@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-sql

ow <oneway_111(at)yahoo(dot)com> writes:
> Sounds pretty bad for my case. Any way to avoid the 10% scan?

Can't see how we optimize your case without pessimizing more-common cases.
Sorry.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message ow 2004-02-13 01:22:53 Re: 7.4 - FK constraint performance
Previous Message ow 2004-02-13 01:03:41 Re: 7.4 - FK constraint performance

Browse pgsql-sql by date

  From Date Subject
Next Message ow 2004-02-13 01:22:53 Re: 7.4 - FK constraint performance
Previous Message ow 2004-02-13 01:03:41 Re: 7.4 - FK constraint performance