Postgres Pro
Downloads
Home   >   mailing lists

Re: drastic reduction in speed of inserts as the table grows - Mailing list pgsql-general

From Tom Lane
Subject Re: drastic reduction in speed of inserts as the table grows
Date
Msg-id 23874.987521637@sss.pgh.pa.us
Whole thread Raw
In response to Re: drastic reduction in speed of inserts as the table grows  (Rini Dutta <rinid@rocketmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Christian Fritze
Date:
Subject: Re: index not used with subselect in where clause ?
Next
From: "Thomas F. O'Connell"
Date:
Subject: Re: View and function