[HACKERS] Perl,Postmaster and CPU question??

2001-08-13 Thread gabriel 


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

---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

Re: [HACKERS] Perl,Postmaster and CPU question??

2001-08-13 Thread Doug McNaught 

gabriel [EMAIL PROTECTED] 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.

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]