Re: question about pending updates in pgstat_report_inj

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: question about pending updates in pgstat_report_inj
Дата
Msg-id 96A96278-4DDA-4FCA-A901-B19D08F2421D@anarazel.de
обсуждение исходный текст
Ответ на question about pending updates in pgstat_report_inj  (Sami Imseih <samimseih@gmail.com>)
Ответы Re: question about pending updates in pgstat_report_inj
Список pgsql-hackers
Hi,

On September 15, 2025 6:11:34 PM EDT, Sami Imseih <samimseih@gmail.com> wrote:
>I have been reviewing how custom cumulative statistics should update their
>counters, and noticed something unexpected in the injection_points example
>[0].
>
>In pgstat_report_inj(), the code updates shared_stats directly:
>
>```
>shstatent = (PgStatShared_InjectionPoint *) entry_ref->shared_stats;
>statent = &shstatent->stats;
>
>/* Update the injection point statistics */
>statent->numcalls++;
>```
>
>This works because it increments shared memory directly, but it bypasses the
>usual pattern where updates go into ->pending and are later flushed into
>shared memory by .flush_pending_cb
>
>I think the more appropriate way to do this is:
>
>```
>    pgstat_report_inj(const char *name)
> {
>        PgStat_EntryRef *entry_ref;
>-       PgStatShared_InjectionPoint *shstatent;
>        PgStat_StatInjEntry *statent;
>
>        /* leave if disabled */
>@@ -174,8 +173,7 @@ pgstat_report_inj(const char *name)
>        entry_ref = pgstat_prep_pending_entry(PGSTAT_KIND_INJECTION, InvalidOid,
>
>           PGSTAT_INJ_IDX(name), NULL);
>
>-       shstatent = (PgStatShared_InjectionPoint *) entry_ref->shared_stats;
>-       statent = &shstatent->stats;
>+       statent = (PgStat_StatInjEntry *) entry_ref->pending;
>
>        /* Update the injection point statistics */
>        statent->numcalls++;
>```
>
>which for example pgstat_report_subscription_error does something
>similar.
>
>Maybe I am missing something obvious for injection_points?

The point of deferring updating shared stats is to avoid contention. That's certainly crucial for something like
relationaccess. But it seems extremely unlikely that there would be contention due to injection point stat updates.  

Greetings,

Andres
--
Sent from my Android device with K-9 Mail. Please excuse my brevity.



В списке pgsql-hackers по дате отправления: