pgsql: Take the statistics collector out of the loop for monitoring

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Take the statistics collector out of the loop for monitoring
Date: 2006-06-19 01:51:22
Message-ID: 20060619015122.1E7889FB1BB@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Log Message:
-----------
Take the statistics collector out of the loop for monitoring backends'
current commands; instead, store current-status information in shared
memory. This substantially reduces the overhead of stats_command_string
and also ensures that pg_stat_activity is fully up to date at all times.
Per my recent proposal.

Modified Files:
--------------
pgsql/doc/src/sgml:
config.sgml (r1.65 -> r1.66)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/config.sgml.diff?r1=1.65&r2=1.66)
monitoring.sgml (r1.33 -> r1.34)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/monitoring.sgml.diff?r1=1.33&r2=1.34)
pgsql/src/backend/postmaster:
pgstat.c (r1.128 -> r1.129)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/postmaster/pgstat.c.diff?r1=1.128&r2=1.129)
postmaster.c (r1.486 -> r1.487)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/postmaster/postmaster.c.diff?r1=1.486&r2=1.487)
pgsql/src/backend/storage/ipc:
ipci.c (r1.83 -> r1.84)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/storage/ipc/ipci.c.diff?r1=1.83&r2=1.84)
procarray.c (r1.11 -> r1.12)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/storage/ipc/procarray.c.diff?r1=1.11&r2=1.12)
pgsql/src/backend/utils/adt:
pgstatfuncs.c (r1.29 -> r1.30)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/pgstatfuncs.c.diff?r1=1.29&r2=1.30)
pgsql/src/backend/utils/misc:
guc.c (r1.321 -> r1.322)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/misc/guc.c.diff?r1=1.321&r2=1.322)
postgresql.conf.sample (r1.179 -> r1.180)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/misc/postgresql.conf.sample.diff?r1=1.179&r2=1.180)
pgsql/src/include:
pgstat.h (r1.46 -> r1.47)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/pgstat.h.diff?r1=1.46&r2=1.47)
pgsql/src/include/storage:
procarray.h (r1.8 -> r1.9)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/storage/procarray.h.diff?r1=1.8&r2=1.9)

Browse pgsql-committers by date

  From Date Subject
Next Message Michael Meskes 2006-06-19 09:19:49 pgsql: Do not use already free'ed errmsg, bug found by Joachim Wieland
Previous Message User Cunha17 2006-06-19 01:03:22 snapshot - src: Starting the ON PREBUILT TABLE implementation