Sample Header Ad - 728x90

PostgreSQL: pg_settings view's "pending_restart" not showing correct value

0 votes
0 answers
158 views
enter image description here I have seeing a strange behaviour with PostgreSQL13 pg_settings system view. I tried updating max_connections using SET command and left without a restart. But if I query from the same session or any new session the pending_restart column in pg_settings is not showing true for this parameter. However if I issue a statement like I attached in the screenshot then pending_restart column shows correctly as `true. What's this behaviour related to?
Asked by goodfella (595 rep)
Aug 2, 2024, 09:07 AM