Re: [SQL] Slow Inserts Again

> >> Why _each_?
> >> Enclose ALL statements by begin; & end; to insert ALL data
> >> in SINGLE transaction:
> 
> But the transaction boundaries wouldn't have anything to do with
> Frank's real problem, which is that the insertions are getting
> slower and slower.  There's no good reason for that; and other
> people are not reporting any comparable problems.  (Considering
> that we *have* been getting trouble reports for more-than-2-gig
> tables, it's clear that people are putting large amounts of data
> into 6.5; so it's not like Frank is stressing the system more
> than it has been before.)
> 
> Frank, what does the memory usage of the backend that's processing
> this insertion look like; has it been growing steadily?  I'm wondering
> whether you could have a problem with poor malloc behavior, or some
> such.

Yes, memory use it the place to look.  We have had bugs in the past that
did not free memory, causing this problem.

--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026