Search Postgresql Archives

Re: autovacuum vacuums entire database...is this right?

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

 



richyen3@xxxxxxxxx escribió:
> It's been about a month and a half, and I'm getting this VACUUM
> again.  This time, I'm wondering if there's any way to tell if
> autovacuum is doing a database-wide vacuum for the sake of xid
> wraparound or for some other reason.  Is there some sort of entry that
> gets put into the log, and if so, what log level would it be at?

No, I don't think we had yet set more extensive logging in autovacuum.

> If this doesn't get logged, could I make this a feature request?

Not really, because starting from 8.2 autovacuum no longer does that.
There is no longer a need for database-wide vacuums.  So if you're
having problems because of that, your best bet is to upgrade.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux