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?
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> Rini Dutta <[EMAIL PROTECTED]> 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 a
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> Rini Dutta <[EMAIL PROTECTED]> 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 a
Rini Dutta <[EMAIL PROTECTED]> 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, t
