Re: Cannot turn track_counts on

> On 16 Apr 2025, at 16:53, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> Anton Shepelev <anton(dot)txt(at)gmail(dot)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