Perl,Postmaster and CPU question??

"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.