Re: [SQL] Slow Inserts Again - Mailing list pgsql-sql

From Tom Lane
Subject Re: [SQL] Slow Inserts Again
Date
Msg-id 28434.925775866@sss.pgh.pa.us
Whole thread Raw
In response to Re: [SQL] Slow Inserts Again  ("Rudy Gireyev" <rgireyev@cnmnetwork.com>)
List pgsql-sql
"Rudy Gireyev" <rgireyev@cnmnetwork.com> writes:
> Is it at all possible that the optimizer is responsible for this behaviour?

Not in the sense that it might be choosing a bad plan --- there is only
one way to insert a tuple ;-).  Size of the table doesn't matter.

If the problem is indeed some kind of memory leak, the optimizer is as
likely a place for the leak as any other, I suppose.
        regards, tom lane


pgsql-sql by date:

Previous
From: "Frank Morton"
Date:
Subject: Re: [SQL] Slow Inserts Again
Next
From: "G. Anthony Reina"
Date:
Subject: Granting select on ALL tables at once