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 23801.987520882@sss.pgh.pa.us
Whole thread Raw
In response to drastic reduction in speed of inserts as the table grows  (Rini Dutta <rinid@rocketmail.com>)
Responses Re: drastic reduction in speed of inserts as the table grows
Another qs Re: drastic reduction in speed of inserts as the table grows
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "Rod Taylor"
Date:
Subject: Re: index not used with subselect in where clause ?
Next
From: Tom Lane
Date:
Subject: Re: failed sanity check, table answers was not found