Re: drastic reduction in speed of inserts as the table grows

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