On 4/17/25 07:23, Tom Lane wrote:
> Anton Shepelev <anton.txt@gmail.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.klaver@aklaver.com