Re: Cannot turn track_counts on

> On 16 Apr 2025, at 16:53, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> Anton Shepelev <anton.txt@gmail.com> writes:
>> pg_settings shows:
>
>>  name    | track_counts
>>  setting | on
>>  source  | override
>
>> What does 'override' mean in the 'source' column?  How can I
>> find where in the system this setting is overridden?
>
> I am fairly certain that there is nothing in core Postgres that
> would do that.  PGC_S_OVERRIDE is used to lock down the values
> of certain variables that shouldn't be allowed to change, but
> track_counts surely isn't one of those.  And a quick grep
> through the code finds nothing applying PGC_S_OVERRIDE to it.
>
> What extensions do you have installed?

Also, is this by any chance a managed instance like Amazon RDS or Azure, or is
it a local database under your control?

--
Daniel Gustafsson