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

From Rini Dutta
Subject Re: drastic reduction in speed of inserts as the table grows
Date
Msg-id 20010417153211.20493.qmail@web12502.mail.yahoo.com
Whole thread Raw
In response to Re: drastic reduction in speed of inserts as the table grows  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: drastic reduction in speed of inserts as the table grows
List pgsql-general
--- Tom Lane <tgl@sss.pgh.pa.us> wrote:
> 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

I'll try it out. Just for my understanding, is the
'lots-of-pending-triggers' problem related to indexes,
or to foreign keys ?

Rini

__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/

pgsql-general by date:

Previous
From: will trillich
Date:
Subject: Re: bpchar type
Next
From: will trillich
Date:
Subject: Re: Problem with function invocation