Horton

Re: pgstat_send_connstats() introduces unnecessary timestamp and UDP overhead

Justin Pryzby <pryzby@telsasoft.com>

View thread View on postgr.es
From: Justin Pryzby <pryzby@telsasoft.com>
To: Andres Freund <andres@anarazel.de>
Cc: Laurenz Albe <laurenz.albe@cybertec.at>, Magnus Hagander <magnus@hagander.net>, pgsql-hackers@postgresql.org
Date: 2021-08-20T19:27:20Z
Lists: pgsql-hackers 
On Tue, Aug 17, 2021 at 02:14:20AM -0700, Andres Freund wrote:
> Doubling the number of UDP messages in common workloads seems also problematic
> enough that it should be addressed for 14. It increases the likelihood of
> dropping stats messages on busy systems, which can have downstream impacts.

I think by "common workloads" you mean one with many, shortlived sessions.

That does sounds like a concern, and I added this as an Opened Item.

-- 
Justin

Commits

  1. Fix performance regression from session statistics.

  2. Add pg_stat_database counters for sessions and session time