RE: [PATCH] Tracking statements entry timestamp in pg_stat_statements

Поиск
Список
Период
Сортировка
Искать
От
kuroda.hayato@fujitsu.com
Тема
RE: [PATCH] Tracking statements entry timestamp in pg_stat_statements
Дата
Msg-id
OSBPR01MB315707830ADA8EBFA0379730F5649@OSBPR01MB3157.jpnprd01.prod.outlook.com
Ответ на
Список
Дерево обсуждения
[PATCH] Tracking statements entry timestamp in pg_stat_statements Andrei Zubkov <zubkov@moonset.ru>
RE: [PATCH] Tracking statements entry timestamp in pg_stat_statements "kuroda.hayato@fujitsu.com" <kuroda.hayato@fujitsu.com>
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements Andrei Zubkov <zubkov@moonset.ru>
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements Julien Rouhaud <rjuju123@gmail.com>
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements Andrei Zubkov <zubkov@moonset.ru>
RE: [PATCH] Tracking statements entry timestamp in pg_stat_statements "kuroda.hayato@fujitsu.com" <kuroda.hayato@fujitsu.com>
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements Andrei Zubkov <zubkov@moonset.ru>
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements Seino Yuki <seinoyu@oss.nttdata.com>
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements Andrei Zubkov <zubkov@moonset.ru>
RE: [PATCH] Tracking statements entry timestamp in pg_stat_statements "kuroda.hayato@fujitsu.com" <kuroda.hayato@fujitsu.com>
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements Andrei Zubkov <zubkov@moonset.ru>
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements Julien Rouhaud <rjuju123@gmail.com>
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements Andrei Zubkov <zubkov@moonset.ru>
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements Andrei Zubkov <zubkov@moonset.ru>
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements Chengxi Sun <sunchengxi@highgo.com>
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements Andrei Zubkov <zubkov@moonset.ru>
Re[2]: [PATCH] Tracking statements entry timestamp in pg_stat_statements Мельников Антон Андреевич <aamelnikov@inbox.ru>
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements Andrei Zubkov <zubkov@moonset.ru>
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements Andrei Zubkov <zubkov@moonset.ru>
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements "Anton A. Melnikov" <aamelnikov@inbox.ru>
Dear Andrei,

> Certaily I was thinking about this. And I've taken an advice of Teodor
> Sigaev - a much more expirienced developer than me. It seems that
> GetCurrentTimestamp() is fast enough for our purpose and we won't call
> it too often - only on new statement entry allocation.

OK.

> However, there is another way - we can store the curent value
> of pg_stat_statements_info.dealloc field when allocating a new
> statement entry instead of timstamping it. Probably, it would be little
> faster, but timestamp seems much more valuable here.

I don't like the idea because such a column has no meaning for the specific row.
I prefer storing timestamp if GetCurrentTimestamp() is cheap.

Best Regards,
Hayato Kuroda
FUJITSU LIMITED

В списке pgsql-hackers по дате отправления
От: Andrei Zubkov
Дата:
От: Kyotaro Horiguchi
Дата:
FAQ