Re: Cannot turn track_counts on

On 4/17/25 07:23, Tom Lane wrote:
> Anton Shepelev <anton(dot)txt(at)gmail(dot)com> writes:
>>> What extensions do you have installed?
>
>> Nothing much:
>
>> db=# show shared_preload_libraries;
>> shared_preload_libraries
>> ---------------------------
>> online_analyze, plantuner
>
> Never heard of either of those, but just from the names, they sound
> like they might be things that would take it on themselves to fool
> with your stats-collection settings. I'd check their code for
> something close to
>
> SetConfigOption("track_counts", ..., PGC_S_OVERRIDE);

I found this:

https://github.com/postgrespro/plantuner/blob/master/plantuner.c

Could not see PGC_S_OVERRIDE in it.

For online_analyze the only code I could find is old:

https://github.com/postgrespro/pgwininstall/blob/master/patches/postgresql/9.6/online_analyze.patch

Again no PGC_S_OVERRIDE.

>
> regards, tom lane
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com