Received: from sss.pgh.pa.us ([216.151.103.158])
	by postgresql.org (8.11.3/8.11.1) with ESMTP id f3HFZRu56627;
	Tue, 17 Apr 2001 11:35:27 -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 f3HFXwR23877;
	Tue, 17 Apr 2001 11:33:58 -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: <20010417153211.20493.qmail@web12502.mail.yahoo.com> 
References: <20010417153211.20493.qmail@web12502.mail.yahoo.com>
Comments: In-reply-to Rini Dutta <rinid@rocketmail.com>
	message dated "Tue, 17 Apr 2001 08:32:11 -0700"
Date: Tue, 17 Apr 2001 11:33:57 -0400
Message-ID: <23874.987521637@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Archive-Number: 200104/697
X-Sequence-Number: 7864

Rini Dutta <rinid@rocketmail.com> writes:
> I'll try it out. Just for my understanding, is the
> 'lots-of-pending-triggers' problem related to indexes,
> or to foreign keys ? 

Foreign keys.  Does your speed problem go away if the table being
inserted into has no foreign keys?

			regards, tom lane