Received: from web12504.mail.yahoo.com (web12504.mail.yahoo.com [216.136.173.196]) by postgresql.org (8.11.3/8.11.1) with SMTP id f3HFfEu58205 for ; Tue, 17 Apr 2001 11:41:14 -0400 (EDT) (envelope-from rinid@rocketmail.com) Message-ID: <20010417154057.84831.qmail@web12504.mail.yahoo.com> Received: from [208.21.31.129] by web12504.mail.yahoo.com; Tue, 17 Apr 2001 08:40:57 PDT Date: Tue, 17 Apr 2001 08:40:57 -0700 (PDT) From: Rini Dutta Subject: Another qs 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/699 X-Sequence-Number: 7869 --- 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 If the degrading performance issue is solved, are JDBC and C still expected to show similar performance in case of inserts ? I"ll probably try it out but just wanted to know if anybody already has an insight in to this. Rini __________________________________________________ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/