[SQL] Re: [GENERAL] drastic reduction in speed of inserts as the table grows

[Tom Lane]

Rini Dutta <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://www.postgresql.org/search.mpl