From: Kevin Brown <kevin@sysexperts.com>
To: pgsql-hackers@postgresql.org
Subject: Re: [PERFORM] Foreign key performance
Date: Tue, 22 Apr 2003 04:44:30 -0700
Message-ID: <20030422114429.GQ1833@filer> (raw)
In-Reply-To: <21359.1050885300@sss.pgh.pa.us>
References: <20030420090304.F28973-200000@megazone23.bigpanda.com>
<6996.1050858564@sss.pgh.pa.us>
<20030421000933.GP1833@filer>
<21359.1050885300@sss.pgh.pa.us>
Tom Lane wrote:
> Kevin Brown <kevin@sysexperts.com> writes:
> > Any chance of backporting these changes to 7_3_STABLE (when you're
> > satisfied they don't break anything)? Just looking at the CVS log for
> > trigger.c, it appears there have been enough changes since then that
> > it might not be easy to do (and since it's not necessarily a "bug fix"
> > as such, it might not qualify for backporting to a stable version).
>
> I'd be pretty hesitant to make such a change in the stable branch ---
> at least not without a lot of testing. If you and others want to
> provide such testing, go to it. The patch appears to apply cleanly
> enough to 7.3, but here's an adjusted patch if fuzz makes you
> nervous...
Thanks, Tom. I've applied the patch to my server and it has so far
passed the few tests I've thrown at it so far (it has detected foreign
key violations in both immediate and deferred trigger mode). And just
so you know, it performs FAR better than the pre-patched version does
-- in the overall transaction I'm doing, I see very little difference
now between deferred triggers and no triggers!
--
Kevin Brown kevin@sysexperts.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: kevin@sysexperts.com, pgsql-hackers@postgresql.org
Subject: Re: [PERFORM] Foreign key performance
In-Reply-To: <20030422114429.GQ1833@filer>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox