Re: PL/Perl Performance Problems

Alex - wrote:
>
> Tom, I am logging these stats now, but i am having a similar issue. both jobs in the morning and after noon insert
about400k records (200k each) 
> In the morning that job takes 450secIn the afternoon only 150; No select, simple parsing a file and insert the
records
> These two tables don't grow as at night a cleanup job removes about the same amount of historical data (older about
40days).  
> Its kind of the same behavior and i don't really see where the swapping fits in.

Are you running vacuum of some sort on this table regularly?

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support