Re: Autoanalyze settings with zero scale factor - Mailing list pgsql-performance

From Tom Lane
Subject Re: Autoanalyze settings with zero scale factor
Date
Msg-id 6362.1169155817@sss.pgh.pa.us
Whole thread Raw
In response to Re: Autoanalyze settings with zero scale factor  ("Jeremy Haile" <jhaile@fastmail.fm>)
Responses Re: Autoanalyze settings with zero scale factor  ("Jeremy Haile" <jhaile@fastmail.fm>)
List pgsql-performance
"Jeremy Haile" <jhaile@fastmail.fm> 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

pgsql-performance by date:

Previous
From: Arjen van der Meijden
Date:
Subject: Re: Configuration Advice
Next
From: Chris Mair
Date:
Subject: Re: [pgsql-advocacy] Postgres and really huge tables