Content-Type: multipart/mixed; boundary="------------6apMN0SDJGzaCIpR0YigUKsu"
Message-ID: <3aaaddc1-dda9-4d5f-ade5-312a66c3e83a@gmail.com>
Date: Sun, 2 Mar 2025 12:42:17 +0200
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Doc: clarify possibility of ephemeral discrepancies between state
 and wait_event in pg_stat_activity
To: Sami Imseih <samimseih@gmail.com>
Cc: pgsql-hackers@lists.postgresql.org
References: <8a275154-a654-44b0-ab37-197802f04c7b@gmail.com>
 <CAA5RZ0ssBs_x=nbrgOViw+E8gBcG0eLHraid1kH-Eg+rx5wm-w@mail.gmail.com>
 <ba25c8f6-eafa-4f6c-a436-5a0824bf9593@gmail.com>
 <CAA5RZ0sRyfuKbzFpLLoHp0=WnerXwyvZz+-fvFdMKyQqRZpQug@mail.gmail.com>
Content-Language: en-US
From: Alex Friedman <alexf01@gmail.com>
In-Reply-To: 
 <CAA5RZ0sRyfuKbzFpLLoHp0=WnerXwyvZz+-fvFdMKyQqRZpQug@mail.gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/3aaaddc1-dda9-4d5f-ade5-312a66c3e83a%40gmail.com>
Precedence: bulk

This is a multi-part message in MIME format.
--------------6apMN0SDJGzaCIpR0YigUKsu
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

> discrepancy will look like. What about we do something much more
> simplified, such
> as the below:
> 
> """
> To keep the reporting overhead low, the system does not attempt to synchronize
> activity data for a backend. As a result, ephemeral discrepancies may
> exist between
> the view’s columns.
> """

Yes, I believe it makes sense to make it more generic. Attached v3 with a slight 
tweak:

+    in the system. To keep the reporting overhead low, the system does not 
attempt to
+    synchronize different aspects of activity data for a backend. As a result, 
ephemeral
+    discrepancies may exist between the view's columns.


Best regards,

Alex Friedman
--------------6apMN0SDJGzaCIpR0YigUKsu
Content-Type: text/plain; charset=UTF-8;
 name="v3-0001-Clarify-possibility-of-ephemeral-discrepancies-be.patch"
Content-Disposition: attachment;
 filename*0="v3-0001-Clarify-possibility-of-ephemeral-discrepancies-be.pa";
 filename*1="tch"
Content-Transfer-Encoding: base64

RnJvbSA1OGRlODg0NjlmNjIwMWFlNjk4ZWUzNGRlYmNkZWMwMjg1MjZhNzJhIE1vbiBTZXAg
MTcgMDA6MDA6MDAgMjAwMQpGcm9tOiBBbGV4IEZyaWVkbWFuIDxhbGV4ZjAxQGdtYWlsLmNv
bT4KRGF0ZTogV2VkLCAyNiBGZWIgMjAyNSAxOTo1OTo1OSArMDIwMApTdWJqZWN0OiBbUEFU
Q0ggdjNdIENsYXJpZnkgcG9zc2liaWxpdHkgb2YgZXBoZW1lcmFsIGRpc2NyZXBhbmNpZXMg
YmV0d2Vlbgogc3RhdGUgYW5kIHdhaXRfZXZlbnQgaW4gcGdfc3RhdF9hY3Rpdml0eS4KCi0t
LQogZG9jL3NyYy9zZ21sL21vbml0b3Jpbmcuc2dtbCB8IDQgKysrLQogMSBmaWxlIGNoYW5n
ZWQsIDMgaW5zZXJ0aW9ucygrKSwgMSBkZWxldGlvbigtKQoKZGlmZiAtLWdpdCBhL2RvYy9z
cmMvc2dtbC9tb25pdG9yaW5nLnNnbWwgYi9kb2Mvc3JjL3NnbWwvbW9uaXRvcmluZy5zZ21s
CmluZGV4IDkxNzhmMWQzNGVmLi4wZTM0YjM1MDliOCAxMDA2NDQKLS0tIGEvZG9jL3NyYy9z
Z21sL21vbml0b3Jpbmcuc2dtbAorKysgYi9kb2Mvc3JjL3NnbWwvbW9uaXRvcmluZy5zZ21s
CkBAIC0xMDE2LDcgKzEwMTYsOSBAQCBwb3N0Z3JlcyAgIDI3MDkzICAwLjAgIDAuMCAgMzAw
OTYgIDI3NTIgPyAgICAgICAgU3MgICAxMTozNCAgIDA6MDAgcG9zdGdyZXM6IHNlcgogICAg
IGl0IG1heSBvciBtYXkgbm90IGJlIDxsaXRlcmFsPndhaXRpbmc8L2xpdGVyYWw+IG9uIHNv
bWUgZXZlbnQuICBJZiB0aGUgc3RhdGUKICAgICBpcyA8bGl0ZXJhbD5hY3RpdmU8L2xpdGVy
YWw+IGFuZCA8c3RydWN0ZmllbGQ+d2FpdF9ldmVudDwvc3RydWN0ZmllbGQ+IGlzIG5vbi1u
dWxsLCBpdAogICAgIG1lYW5zIHRoYXQgYSBxdWVyeSBpcyBiZWluZyBleGVjdXRlZCwgYnV0
IGlzIGJlaW5nIGJsb2NrZWQgc29tZXdoZXJlCi0gICAgaW4gdGhlIHN5c3RlbS4KKyAgICBp
biB0aGUgc3lzdGVtLiBUbyBrZWVwIHRoZSByZXBvcnRpbmcgb3ZlcmhlYWQgbG93LCB0aGUg
c3lzdGVtIGRvZXMgbm90IGF0dGVtcHQgdG8KKyAgICBzeW5jaHJvbml6ZSBkaWZmZXJlbnQg
YXNwZWN0cyBvZiBhY3Rpdml0eSBkYXRhIGZvciBhIGJhY2tlbmQuIEFzIGEgcmVzdWx0LCBl
cGhlbWVyYWwKKyAgICBkaXNjcmVwYW5jaWVzIG1heSBleGlzdCBiZXR3ZWVuIHRoZSB2aWV3
J3MgY29sdW1ucy4KICAgIDwvcGFyYT4KICAgPC9ub3RlPgogCi0tIAoyLjQxLjAKCg==

--------------6apMN0SDJGzaCIpR0YigUKsu--