Re: Issue enabling track_counts to launch autovacuum in 9.4.5

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: Derek Elder <dereke(at)mirthcorp(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Issue enabling track_counts to launch autovacuum in 9.4.5
Date: 2016-03-02 21:36:48
Message-ID: 20160302213648.GA486438@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Derek Elder wrote:

> From what I had read, this setting should be on by default. When I checked
> our other servers I see that track_counts is on and the autovacuum process
> is working correctly on them. Indeed we don't even have the setting
> explicitly listed in our postgresql.conf on these servers.
>
> We first tried a simple restart, but that didn't work.

Try
ALTER SYSTEM RESET track_counts;

--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2016-03-02 21:37:02 Re: Issue enabling track_counts to launch autovacuum in 9.4.5
Previous Message Vitaly Burovoy 2016-03-02 21:33:40 Re: Slow Query - Postgres 9.2