Re: Autoanalyze settings with zero scale factor

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

 



"Jeremy Haile" <jhaile@xxxxxxxxxxx> writes:
> No tables have been vacuumed or analyzed today.  I had thought that this
> problem was due to my pg_autovacuum changes, but perhaps not.  I
> restarted PostgreSQL (in production - yikes)  About a minute after being
> restarted, the autovac process fired up.

> What could get PG in a state where autovac isn't running?

Um, are you sure it wasn't?  The autovac process is not an always-there
thing, it quits after each pass and then the postmaster starts a new one
awhile later.

			regards, tom lane


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux