]> granicus.if.org Git - postgresql/commit
Implement rate-limiting logic on how often backends will attempt to send
authorTom Lane <tgl@sss.pgh.pa.us>
Mon, 30 Apr 2007 03:23:49 +0000 (03:23 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Mon, 30 Apr 2007 03:23:49 +0000 (03:23 +0000)
commit957d08c81f9cc277725c83b9381c5154b6318a5e
tree1c665d6e63c2cb02156df44a3519d2a0bebcaea3
parent57b82bf324285464783796e5614d5f9aadd0817f
Implement rate-limiting logic on how often backends will attempt to send
messages to the stats collector.  This avoids the problem that enabling
stats_row_level for autovacuum has a significant overhead for short
read-only transactions, as noted by Arjen van der Meijden.  We can avoid
an extra gettimeofday call by piggybacking on the one done for WAL-logging
xact commit or abort (although that doesn't help read-only transactions,
since they don't WAL-log anything).

In my proposal for this, I noted that we could change the WAL log entries
for commit/abort to record full TimestampTz precision, instead of only
time_t as at present.  That's not done in this patch, but will be committed
separately.
src/backend/access/transam/xact.c
src/backend/commands/analyze.c
src/backend/commands/vacuumlazy.c
src/backend/postmaster/pgstat.c
src/backend/utils/adt/timestamp.c
src/include/access/xact.h
src/include/utils/timestamp.h
src/test/regress/expected/stats.out
src/test/regress/sql/stats.sql