Re: Issue enabling track_counts to launch autovacuum in 9.4.5 - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Issue enabling track_counts to launch autovacuum in 9.4.5
Date
Msg-id 20160302213648.GA486438@alvherre.pgsql
Whole thread Raw
In response to Issue enabling track_counts to launch autovacuum in 9.4.5  (Derek Elder <dereke@mirthcorp.com>)
Responses Re: Issue enabling track_counts to launch autovacuum in 9.4.5  (Derek Elder <dereke@mirthcorp.com>)
List 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


pgsql-general by date:

Previous
From: Vitaly Burovoy
Date:
Subject: Re: Slow Query - Postgres 9.2
Next
From: "David G. Johnston"
Date:
Subject: Re: Issue enabling track_counts to launch autovacuum in 9.4.5