Thread: Perl,Postmaster and CPU question??

Perl,Postmaster and CPU question??

From
"gabriel"
Date:
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...


Re: Perl,Postmaster and CPU question??

From
Doug McNaught
Date:
"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.