X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 38B35D1C916 for ; Wed, 6 Aug 2003 22:07:12 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 86307-10 for ; Wed, 6 Aug 2003 19:05:51 -0300 (ADT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 3CF3CD1C910 for ; Wed, 6 Aug 2003 19:07:01 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.9/8.12.9) with ESMTP id h76M6qSa009347; Wed, 6 Aug 2003 18:06:53 -0400 (EDT) To: Stephan Szabo Cc: Sebastien Lemieux , Postgresql-performance Subject: Re: How to efficiently duplicate a whole schema? In-reply-to: <20030806143746.J7786-100000@megazone.bigpanda.com> References: <20030806143746.J7786-100000@megazone.bigpanda.com> Comments: In-reply-to Stephan Szabo message dated "Wed, 06 Aug 2003 14:41:43 -0700" Date: Wed, 06 Aug 2003 18:06:52 -0400 Message-ID: <9346.1060207612@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/124 X-Sequence-Number: 2941 Stephan Szabo writes: > Another thing might be the management of the trigger queue. I don't think > 7.3.2 had the optimization for limiting the scans of the queue when you > have lots of deferred triggers. It looks like 7.3.4 may though. Good point. We put that in in 7.3.3, according to the CVS logs. regards, tom lane