Re: [16Beta1][doc] pgstat: Track time of the last scan of a relation
От | David Rowley |
---|---|
Тема | Re: [16Beta1][doc] pgstat: Track time of the last scan of a relation |
Дата | |
Msg-id | CAApHDvr2WOUdnvJemheTXtONC6KdWrBwSxLCN8b687+vLFbKyQ@mail.gmail.com обсуждение исходный текст |
Ответ на | [16Beta1][doc] pgstat: Track time of the last scan of a relation ("Shinoda, Noriyoshi (PN Japan FSIP)" <noriyoshi.shinoda@hpe.com>) |
Ответы |
RE: [16Beta1][doc] pgstat: Track time of the last scan of a relation
|
Список | pgsql-hackers |
On Wed, 31 May 2023 at 15:57, Shinoda, Noriyoshi (PN Japan FSIP) <noriyoshi.shinoda@hpe.com> wrote: > According to the documentation [2], the data type of the columns added to these views is 'timestamptz'. > However, columns of the same data type in pg_stat_all_tables.last_vacuum, last_analyze and other tables are unified to'timestamp with time zone'. The attached patch changes the data type of the added column from timestamptz to timestampwith time zone. I agree that it would be good to make those consistently use timestamp with time zone for all columns of that type in the docs for pg_stat_all_tables. More generally, it might be good if we did it for the entire docs: doc $ git grep "<type>timestamptz</type>" | wc -l 17 doc $ git grep "<type>timestamp with time zone</type>" | wc -l 74 Clearly "timestamp with time zone" is much more commonly used. The bar is probably set a bit higher for changing the longer-established ones, however. David
В списке pgsql-hackers по дате отправления: