pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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




view thread (18+ messages)  latest in thread

Message-ID: <20030422114429.GQ1833@filer>
Permalink:  ../20030422114429.GQ1833@filer/
Also on:    postgresql.org/message-id/20030422114429.GQ1833@filer

 · 

reply

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