Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 9A63E475A9E for ; Fri, 22 Nov 2002 17:37:03 -0500 (EST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id 14169475A09 for ; Fri, 22 Nov 2002 17:37:03 -0500 (EST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.6/8.12.6) with ESMTP id gAMMb4sX028829; Fri, 22 Nov 2002 17:37:04 -0500 (EST) To: "Jason E. Stewart" Cc: pgsql-interfaces@postgresql.org Subject: Re: Frontend/Backend protocol changes? 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> Comments: In-reply-to "Jason E. Stewart" message dated "22 Nov 2002 14:34:20 -0700" Date: Fri, 22 Nov 2002 17:37:03 -0500 Message-ID: <28828.1038004623@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200211/107 X-Sequence-Number: 3355 "Jason E. Stewart" 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