public inbox for [email protected]help / color / mirror / Atom feed
Re: Cannot turn track_counts on 4+ messages / 3 participants [nested] [flat]
* Re: Cannot turn track_counts on @ 2025-04-17 14:05 Anton Shepelev <[email protected]> 2025-04-17 14:23 ` Re: Cannot turn track_counts on Tom Lane <[email protected]> 2025-04-17 15:17 ` Re: Cannot turn track_counts on Adrian Klaver <[email protected]> 0 siblings, 2 replies; 4+ messages in thread From: Anton Shepelev @ 2025-04-17 14:05 UTC (permalink / raw) To: Tom Lane <[email protected]>; +Cc: pgsql-general Tom Lane to Anton Shepelev: > > I have a Postgres sever with the 'track_counts' setting > > stuck in 'off'. [...] > > 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. Thanks for checking it, Tom. > What extensions do you have installed? Nothing much: db=# show shared_preload_libraries; shared_preload_libraries --------------------------- online_analyze, plantuner db=# \dx List of installed extensions Name | Version | Schema | Description ---------+---------+------------+------------------------------ plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language -- () ascii ribbon campaign -- against html e-mail /\ www.asciiribbon.org -- against proprietary attachments ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Cannot turn track_counts on 2025-04-17 14:05 Re: Cannot turn track_counts on Anton Shepelev <[email protected]> @ 2025-04-17 14:23 ` Tom Lane <[email protected]> 2025-04-17 15:16 ` Re: Cannot turn track_counts on Adrian Klaver <[email protected]> 1 sibling, 1 reply; 4+ messages in thread From: Tom Lane @ 2025-04-17 14:23 UTC (permalink / raw) To: Anton Shepelev <[email protected]>; +Cc: pgsql-general Anton Shepelev <[email protected]> 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); regards, tom lane ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Cannot turn track_counts on 2025-04-17 14:05 Re: Cannot turn track_counts on Anton Shepelev <[email protected]> 2025-04-17 14:23 ` Re: Cannot turn track_counts on Tom Lane <[email protected]> @ 2025-04-17 15:16 ` Adrian Klaver <[email protected]> 0 siblings, 0 replies; 4+ messages in thread From: Adrian Klaver @ 2025-04-17 15:16 UTC (permalink / raw) To: Tom Lane <[email protected]>; Anton Shepelev <[email protected]>; +Cc: pgsql-general On 4/17/25 07:23, Tom Lane wrote: > Anton Shepelev <[email protected]> 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 [email protected] ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Cannot turn track_counts on 2025-04-17 14:05 Re: Cannot turn track_counts on Anton Shepelev <[email protected]> @ 2025-04-17 15:17 ` Adrian Klaver <[email protected]> 1 sibling, 0 replies; 4+ messages in thread From: Adrian Klaver @ 2025-04-17 15:17 UTC (permalink / raw) To: Anton Shepelev <[email protected]>; Tom Lane <[email protected]>; +Cc: pgsql-general On 4/17/25 07:05, Anton Shepelev wrote: > Tom Lane to Anton Shepelev: > >>> I have a Postgres sever with the 'track_counts' setting >>> stuck in 'off'. [...] >> >> 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. > > Thanks for checking it, Tom. > >> What extensions do you have installed? > > Nothing much: > > db=# show shared_preload_libraries; > shared_preload_libraries > --------------------------- > online_analyze, plantuner Are you running PostgresPro? Both those modules are associated with it: https://postgrespro.com/docs/postgrespro/17/contrib.html If you are you might want to talk to their tech support. > > db=# \dx > List of installed extensions > Name | Version | Schema | Description > ---------+---------+------------+------------------------------ > plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language > -- Adrian Klaver [email protected] ^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2025-04-17 15:17 UTC | newest] Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2025-04-17 14:05 Re: Cannot turn track_counts on Anton Shepelev <[email protected]> 2025-04-17 14:23 ` Tom Lane <[email protected]> 2025-04-17 15:16 ` Adrian Klaver <[email protected]> 2025-04-17 15:17 ` Adrian Klaver <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox