Content-Type: multipart/mixed; boundary="------------rq8m3uY56B0zes9t50D8Sqfq"
Message-ID: <ba25c8f6-eafa-4f6c-a436-5a0824bf9593@gmail.com>
Date: Wed, 26 Feb 2025 23:01:48 +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>
Content-Language: en-US
From: Alex Friedman <alexf01@gmail.com>
In-Reply-To: 
 <CAA5RZ0ssBs_x=nbrgOViw+E8gBcG0eLHraid1kH-Eg+rx5wm-w@mail.gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/ba25c8f6-eafa-4f6c-a436-5a0824bf9593%40gmail.com>
Precedence: bulk

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

On 26/02/2025 22:00, Sami Imseih wrote:
> If we do need to document anything, which I am not convinced we should,
> it should be more generic.

Thanks for the feedback, I've attached a v2 patch which has wording that's a bit 
more generic.

It's also worth noting that pg_locks already has a full paragraph explaining 
inconsistencies, so in my opinion it's worth it at least mentioning something 
similar here for pg_stat_activity.


Best regards,

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

RnJvbSBmYmJmYzYyM2UxNmVkOTcxNzZjMGNjZjBlYmM1MzRkMTE4ZTlmMjUyIE1vbiBTZXAg
MTcgMDA6MDA6MDAgMjAwMQpGcm9tOiBBbGV4IEZyaWVkbWFuIDxhbGV4ZjAxQGdtYWlsLmNv
bT4KRGF0ZTogV2VkLCAyNiBGZWIgMjAyNSAxOTo1OTo1OSArMDIwMApTdWJqZWN0OiBbUEFU
Q0ggdjJdIENsYXJpZnkgcG9zc2liaWxpdHkgb2YgZXBoZW1lcmFsIGRpc2NyZXBhbmNpZXMg
YmV0d2Vlbgogc3RhdGUgYW5kIHdhaXRfZXZlbnQgaW4gcGdfc3RhdF9hY3Rpdml0eS4KCi0t
LQogZG9jL3NyYy9zZ21sL21vbml0b3Jpbmcuc2dtbCB8IDYgKysrKystCiAxIGZpbGUgY2hh
bmdlZCwgNSBpbnNlcnRpb25zKCspLCAxIGRlbGV0aW9uKC0pCgpkaWZmIC0tZ2l0IGEvZG9j
L3NyYy9zZ21sL21vbml0b3Jpbmcuc2dtbCBiL2RvYy9zcmMvc2dtbC9tb25pdG9yaW5nLnNn
bWwKaW5kZXggOTE3OGYxZDM0ZWYuLmRlNDk3NjlkNDA3IDEwMDY0NAotLS0gYS9kb2Mvc3Jj
L3NnbWwvbW9uaXRvcmluZy5zZ21sCisrKyBiL2RvYy9zcmMvc2dtbC9tb25pdG9yaW5nLnNn
bWwKQEAgLTEwMTYsNyArMTAxNiwxMSBAQCBwb3N0Z3JlcyAgIDI3MDkzICAwLjAgIDAuMCAg
MzAwOTYgIDI3NTIgPyAgICAgICAgU3MgICAxMTozNCAgIDA6MDAgcG9zdGdyZXM6IHNlcgog
ICAgIGl0IG1heSBvciBtYXkgbm90IGJlIDxsaXRlcmFsPndhaXRpbmc8L2xpdGVyYWw+IG9u
IHNvbWUgZXZlbnQuICBJZiB0aGUgc3RhdGUKICAgICBpcyA8bGl0ZXJhbD5hY3RpdmU8L2xp
dGVyYWw+IGFuZCA8c3RydWN0ZmllbGQ+d2FpdF9ldmVudDwvc3RydWN0ZmllbGQ+IGlzIG5v
bi1udWxsLCBpdAogICAgIG1lYW5zIHRoYXQgYSBxdWVyeSBpcyBiZWluZyBleGVjdXRlZCwg
YnV0IGlzIGJlaW5nIGJsb2NrZWQgc29tZXdoZXJlCi0gICAgaW4gdGhlIHN5c3RlbS4KKyAg
ICBpbiB0aGUgc3lzdGVtLiBUbyBrZWVwIHRoZSByZXBvcnRpbmcgbG93LW92ZXJoZWFkLCB0
aGUgc3lzdGVtIHVzZXMgdmVyeSBsaWdodHdlaWdodAorICAgIHN5bmNocm9uaXphdGlvbi4g
QXMgYSByZXN1bHQsIGVwaGVtZXJhbCBkaXNjcmVwYW5jaWVzIGJldHdlZW4gdGhlIHZpZXcn
cyBjb2x1bW5zLAorICAgIGZvciBleGFtcGxlIGJldHdlZW4gPHN0cnVjdGZpZWxkPndhaXRf
ZXZlbnQ8L3N0cnVjdGZpZWxkPiBhbmQKKyAgICA8c3RydWN0ZmllbGQ+c3RhdGU8L3N0cnVj
dGZpZWxkPiwgb3IgYmV0d2VlbiA8c3RydWN0ZmllbGQ+c3RhdGU8L3N0cnVjdGZpZWxkPiBh
bmQKKyAgICA8c3RydWN0ZmllbGQ+cXVlcnlfaWQ8L3N0cnVjdGZpZWxkPiwgYXJlIHBvc3Np
YmxlIGJ5IG5hdHVyZS4KICAgIDwvcGFyYT4KICAgPC9ub3RlPgogCi0tIAoyLjQxLjAKCg==


--------------rq8m3uY56B0zes9t50D8Sqfq--