Search Postgresql Archives

Re: Re: significant performance hit whenever autovacuum runs after upgrading from 9.0 -> 9.1

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



 On Mon, May 21, 2012 at 2:05 PM, Lonni J Friedman<netllama@xxxxxxxxx>  wrote:
Greetings,
When I got in this morning, I found
an autovacuum process that had been running since just before the load
spiked,

Autovacuum might need to set the freeze bit very first time it runs.  I recall hearing advice about running a 'vacuum freeze' after you insert a huge amount of data.  And I recall pg_upgrade doesn't write stats, so did you analyze your database?

Or, maybe its not vacuum... maybe some of your sql statements are planning differently and running really bad.  Can you check some?  Can you log slow queries?

Have you checked the status of your raid?  Maybe you lost a drive and its in recovery and you have very slow IO?

-Andy

--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Programming PHP]     [Kernel Newbies]     [PHP Classes]     [Find Someone Nice]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

Add to Google Powered by Linux