Re: [HACKERS] [SQL] 7.4 - FK constraint performance

2004-06-03 Thread Stephan Szabo
On Sun, 15 Feb 2004, Stephan Szabo wrote: > On Fri, 13 Feb 2004, Stephan Szabo wrote: > > > > > On Fri, 13 Feb 2004, Tom Lane wrote: > > > > > Stephan Szabo <[EMAIL PROTECTED]> writes: > > > > On Fri, 13 Feb 2004, Tom Lane wrote: > > > >> I was looking at that last night. It seems like we could a

Re: [HACKERS] [SQL] 7.4 - FK constraint performance

2004-02-18 Thread Tom Lane
Stephan Szabo <[EMAIL PROTECTED]> writes: > I did this, and changed the foreign keys to use it, but I haven't managed > to build a fk case where I could actually detect a change in the plan > chosen. Since the queries are only a simple scan on the one table I'm > wondering if it's basically just m

Re: [HACKERS] [SQL] 7.4 - FK constraint performance

2004-02-15 Thread Stephan Szabo
On Fri, 13 Feb 2004, Stephan Szabo wrote: > > On Fri, 13 Feb 2004, Tom Lane wrote: > > > Stephan Szabo <[EMAIL PROTECTED]> writes: > > > On Fri, 13 Feb 2004, Tom Lane wrote: > > >> I was looking at that last night. It seems like we could add a LIMIT at > > >> least in some contexts. In the case