Re: [PERFORM] Foreign key performance

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Kevin Brown <kevin(at)sysexperts(dot)com>, <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [PERFORM] Foreign key performance
Date: 2003-04-20 16:04:10
Message-ID: 20030420090304.F28973-200000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-performance

On Sat, 19 Apr 2003, Stephan Szabo wrote:

> On Sat, 19 Apr 2003, Tom Lane wrote:
>
> > Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> writes:
> > > The hack was just the keeping around the list pointer from the last run
> > > through (see attached - passed simple fk tests and regression, but there
> > > might be problems I don't see).
> >
> > Shouldn't this patch update the comment in deferredTriggerInvokeEvents
> > (c. line 1860 in cvs tip)?
>
> Probably, since the second part of that is basically what this is. I'll
> update and send updated patch tomorrow.

Okay, this changes the second paragraph of that comment. I left in the
comment that's really similar next to where I actually do the selection of
which start point to use.

Attachment Content-Type Size
trigger.patch text/plain 4.8 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2003-04-20 16:16:20 Re: default locale considered harmful? (was Re: [GENERAL]
Previous Message Cadili 2003-04-20 09:06:51 Re: How to write make rules for shared library and

Browse pgsql-performance by date

  From Date Subject
Next Message Andrew Sullivan 2003-04-20 16:46:09 Re: [SQL] Yet Another (Simple) Case of Index not used
Previous Message Andreas Pflug 2003-04-20 15:37:57 Re: [SQL] Yet Another (Simple) Case of Index not used