On 27 Aug 2003 at 15:50, Tarhon-Onu Victor wrote: > > Hi, > > I have a (big) problem with postgresql when making lots of > inserts per second. I have a tool that is generating an output of ~2500 > lines per seconds. I write a script in PERL that opens a pipe to that > tool, reads every line and inserts data. > I tryed both commited and not commited variants (the inserts > were commited at every 60 seconds), and the problem persists.
Assuming one record per line, you are committing after 150K records, that's not good. Try committing every 5 seconds. And open more than one conenction. That will certainly improve performance. Afterall concurrency is biggest assset of postgresql. Fiddle around with combination and see which works best for you. Bye Shridhar -- Mencken and Nathan's Ninth Law of The Average American: The quality of a champagne is judged by the amount of noise the cork makes when it is popped. ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
