Re: PL/Perl Performance Problems

I run AutovacuumI run a Vaccum Full Analyze every SatI re-index the tables every Sat

> Date: Fri, 18 Dec 2009 21:20:23 -0300
> From: alvherre(at)commandprompt(dot)com
> To: aintokyo(at)hotmail(dot)com
> CC: tgl(at)sss(dot)pgh(dot)pa(dot)us; pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] 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 about 400k 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 40 days).
> > 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
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general

_________________________________________________________________
A world FIRST in property search has arrived! Check out Domain Radar NOW!
http://clk.atdmt.com/NMN/go/157631292/direct/01/