Received: from sss.pgh.pa.us ([216.151.103.158])
	by postgresql.org (8.11.3/8.11.1) with ESMTP id f3HFLUu53140;
	Tue, 17 Apr 2001 11:21:30 -0400 (EDT)
	(envelope-from tgl@sss.pgh.pa.us)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.11.3/8.11.3) with ESMTP id f3HFLMR23804;
	Tue, 17 Apr 2001 11:21:22 -0400 (EDT)
To: Rini Dutta <rinid@rocketmail.com>
cc: pgsql-sql@postgresql.org, pgsql-general@postgresql.org,
	pgsql-interfaces@postgresql.org
Subject: Re: drastic reduction in speed of inserts as the table grows 
In-reply-to: <20010417142853.64642.qmail@web12507.mail.yahoo.com> 
References: <20010417142853.64642.qmail@web12507.mail.yahoo.com>
Comments: In-reply-to Rini Dutta <rinid@rocketmail.com>
	message dated "Tue, 17 Apr 2001 07:28:53 -0700"
Date: Tue, 17 Apr 2001 11:21:22 -0400
Message-ID: <23801.987520882@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Archive-Number: 200104/693
X-Sequence-Number: 7855

Rini Dutta <rinid@rocketmail.com> 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