From: Tom Lane <tgl@sss.pgh.pa.us>
To: Jason E. Stewart <jason@openinformatics.com>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: Frontend/Backend protocol changes?
Date: Fri, 22 Nov 2002 17:37:03 -0500
Message-ID: <28828.1038004623@sss.pgh.pa.us> (raw)
In-Reply-To: <87ptsx70gz.fsf@openinformatics.com>
References: <87of8ha7ch.fsf@openinformatics.com>
<25204.1037984494@sss.pgh.pa.us>
<877kf5a5md.fsf@openinformatics.com>
<26177.1037992260@sss.pgh.pa.us>
<87ptsx70gz.fsf@openinformatics.com>
"Jason E. Stewart" <jason@openinformatics.com> writes:
> Are all the RI_ConstraintTrigger_XXXXX triggers on _other_ tables that
> affect this table in some way??? Because Audit shouldn't have any.
You should check, but I think those are all going to be ON UPDATE or ON
DELETE triggers, if they all appear to be in pairs. You probably have a
bunch of FK's referencing Audit from other tables? If so, they are not
hurting your insert performance. But an update or delete in Audit would
be expensive.
(BTW, I'm having a hard time visualizing why an audit-trail table would
be referenced by FKs from other tables.)
regards, tom lane
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-interfaces@postgresql.org
Cc: tgl@sss.pgh.pa.us, jason@openinformatics.com
Subject: Re: Frontend/Backend protocol changes?
In-Reply-To: <28828.1038004623@sss.pgh.pa.us>
* 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