Thread

1. Perl,Postmaster and CPU question??

   gabriel <gabriel@workingnetsp.com.br> — 2001-08-13T14:27:05Z

   hello all 
   
   I have a perl script that read a text file and 
   insert the data in a table...
   
   but when this script is runing the usage of CPU by postmaster grows to
   between 79 and 90 percent...
   
   there's something to do about it?
   
   thanks...
   
   

2. Re: Perl,Postmaster and CPU question??

   Doug McNaught <doug@wireboard.com> — 2001-08-13T18:14:13Z

   "gabriel" <gabriel@workingnetsp.com.br> writes:
   
   > hello all 
   > 
   > I have a perl script that read a text file and 
   > insert the data in a table...
   > 
   > but when this script is runing the usage of CPU by postmaster grows to
   > between 79 and 90 percent...
   
   And this is a problem because...  ?
   
   Honestly, you're doing a lot of work, why wouldn't the CPU be busy?
   
   > there's something to do about it?
   
   Are you using COPY or a series of INSERTs?  If the latter, are you
   doing them all inside a transaction?  INSERTs not wrapped in a
   transaction will load the system a lot more due to transaction
   overhead and disk sync latency.
   
   -Doug
   -- 
   Free Dmitry Sklyarov! 
   http://www.freesklyarov.org/ 
   
   We will return to our regularly scheduled signature shortly.