I run Autovacuum
I run a Vaccum Full Analyze every Sat
I re-index the tables every Sat
> Date: Fri, 18 Dec 2009 21:20:23 -0300
> From: alvherre@commandprompt.com
> To: aintokyo@hotmail.com
> CC: tgl@sss.pgh.pa.us; pgsql-general@postgresql.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@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
Check out Domain Radar NOW!
A world FIRST in property search has arrived!