Received: from web12502.mail.yahoo.com (web12502.mail.yahoo.com [216.136.173.194]) by postgresql.org (8.11.3/8.11.1) with SMTP id f3HFWGu55825 for ; Tue, 17 Apr 2001 11:32:16 -0400 (EDT) (envelope-from rinid@rocketmail.com) Message-ID: <20010417153211.20493.qmail@web12502.mail.yahoo.com> Received: from [208.21.31.129] by web12502.mail.yahoo.com; Tue, 17 Apr 2001 08:32:11 PDT Date: Tue, 17 Apr 2001 08:32:11 -0700 (PDT) From: Rini Dutta Subject: Re: drastic reduction in speed of inserts as the table grows To: Tom Lane Cc: pgsql-sql@postgresql.org, pgsql-general@postgresql.org, pgsql-interfaces@postgresql.org In-Reply-To: <23801.987520882@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200104/696 X-Sequence-Number: 7861 --- Tom Lane wrote: > Rini Dutta writes: > > Here is the performance statistics on the same > table. > > Note the fall in performance as the test proceeds. > > Try 7.1. I think you are running into the > lots-of-pending-triggers > problem that was found and fixed awhile back. > > regards, tom lane I'll try it out. Just for my understanding, is the 'lots-of-pending-triggers' problem related to indexes, or to foreign keys ? Rini __________________________________________________ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/