|
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@xxxxxxxxxxxxxxxxx > To: aintokyo@xxxxxxxxxxx > CC: tgl@xxxxxxxxxxxxx; pgsql-general@xxxxxxxxxxxxxx > Subject: 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 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@xxxxxxxxxxxxxx) > 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! |
