diff options
| author |  Glen Miner | 2024-12-17 12:47:46 -0500 |
|---|---|---|
| committer |  Sadie Powell | 2024-12-19 14:10:08 +0000 |
| commit | d2df7b24c0494f6da09353518bee9e5d9fba8b38 (patch) | |
| tree | f1d0ef620b734302edb90d0bc4a8d2ffce09b95b /docs/sql/log_sql/pgsql.sql | |
| parent | Optimized membership lookup for large servers (diff) | |
Optimized WHO command
On our server hosting 150K users we noticed that the WHO command was high on the perf capture profile and on closer inspection we noticed that the majority of users do not have the invisible mode set.
Since IsModeSet is a small inline function that does an array lookup we were able to reduce server load by calling IsModeSet first to short-circuit the comparatively expensive SharesChannelWith call.
Diffstat (limited to 'docs/sql/log_sql/pgsql.sql')
0 files changed, 0 insertions, 0 deletions