Re: UUID v7
От
Chris Travers
Тема
Re: UUID v7
Дата
Msg-id
169684654521.1130.7798729884309122343.pgcf@coridan.postgresql.org
Ответ на
Re: UUID v7 (Andrey M. Borodin)
Список
Дерево обсуждения
UUID v7 Andrey Borodin <amborodin86@gmail.com>
Re: UUID v7 Andres Freund <andres@anarazel.de>
Re: UUID v7 Tom Lane <tgl@sss.pgh.pa.us>
Re: UUID v7 Andrey Borodin <amborodin86@gmail.com>
Re: UUID v7 Peter Eisentraut <peter.eisentraut@enterprisedb.com>
RE: UUID v7 "Kyzer Davis (kydavis)" <kydavis@cisco.com>
Re: UUID v7 Nikolay Samokhvalov <samokhvalov@gmail.com>
Re: UUID v7 Daniel Gustafsson <daniel@yesql.se>
Re: UUID v7 Matthias van de Meent <boekewurm+postgres@gmail.com>
Re: UUID v7 Daniel Gustafsson <daniel@yesql.se>
Re: UUID v7 Tom Lane <tgl@sss.pgh.pa.us>
Re: UUID v7 Peter Eisentraut <peter.eisentraut@enterprisedb.com>
Re: UUID v7 "Andrey M. Borodin" <x4mmm@yandex-team.ru>
Re: UUID v7 Peter Eisentraut <peter.eisentraut@enterprisedb.com>
Re: UUID v7 "Andrey M. Borodin" <x4mmm@yandex-team.ru>
Re: UUID v7 "Andrey M. Borodin" <x4mmm@yandex-team.ru>
Re: UUID v7 "Andrey M. Borodin" <x4mmm@yandex-team.ru>
Re: UUID v7 "Andrey M. Borodin" <x4mmm@yandex-team.ru>
Re: UUID v7 Mat Arye <mat@timescaledb.com>
Re: UUID v7 "Andrey M. Borodin" <x4mmm@yandex-team.ru>
Re: UUID v7 Chris Travers <chris.travers@gmail.com>
Re: UUID v7 Nick Babadzhanian <pgnickb@gmail.com>
Re: UUID v7 Jelte Fennema <postgres@jeltef.nl>
Re: UUID v7 Brad Peabody <brad@peabody.io>
Re: UUID v7 Andrey Borodin <amborodin86@gmail.com>
Re: UUID v7 "Andrey M. Borodin" <x4mmm@yandex-team.ru>
Re: UUID v7 "Andrey M. Borodin" <x4mmm@yandex-team.ru>
Re: Re: UUID v7 Przemysław Sztoch <przemyslaw@sztoch.pl>
Re: UUID v7 "Andrey M. Borodin" <x4mmm@yandex-team.ru>
Re: UUID v7 Jelte Fennema-Nio <postgres@jeltef.nl>
Re: UUID v7 Przemysław Sztoch <przemyslaw@sztoch.pl>
Re: UUID v7 Sergey Prokhorenko <sergeyprokhorenko@yahoo.com.au>
Re: UUID v7 Andrey Borodin <x4mmm@yandex-team.ru>
Re: UUID v7 Przemysław Sztoch <przemyslaw@sztoch.pl>
Re: UUID v7 Aleksander Alekseev <aleksander@timescale.com>
Re: UUID v7 "Andrey M. Borodin" <x4mmm@yandex-team.ru>
Re: UUID v7 Sergey Prokhorenko <sergeyprokhorenko@yahoo.com.au>
Re: UUID v7 "Andrey M. Borodin" <x4mmm@yandex-team.ru>
Re: UUID v7 Jelte Fennema-Nio <postgres@jeltef.nl>
Re: UUID v7 Przemysław Sztoch <przemyslaw@sztoch.pl>
Re: UUID v7 Jelte Fennema-Nio <postgres@jeltef.nl>
Re: UUID v7 Andrey Borodin <x4mmm@yandex-team.ru>
Re: UUID v7 Przemysław Sztoch <przemyslaw@sztoch.pl>
Re: UUID v7 Lukas Fittl <lukas@fittl.com>
Re: UUID v7 Jelte Fennema-Nio <postgres@jeltef.nl>
Re: UUID v7 Przemysław Sztoch <przemyslaw@sztoch.pl>
Re: UUID v7 Aleksander Alekseev <aleksander@timescale.com>
Re: UUID v7 Andrey Borodin <x4mmm@yandex-team.ru>
Re: UUID v7 Andrey Borodin <x4mmm@yandex-team.ru>
Re: UUID v7 Sergey Prokhorenko <sergeyprokhorenko@yahoo.com.au>
Re: UUID v7 "David G. Johnston" <david.g.johnston@gmail.com>
Re: UUID v7 Andrey Borodin <x4mmm@yandex-team.ru>
Re: UUID v7 Andrey Borodin <x4mmm@yandex-team.ru>
Re: UUID v7 Nikolay Samokhvalov <nik@postgres.ai>
Re: UUID v7 Sergey Prokhorenko <sergeyprokhorenko@yahoo.com.au>
Re: UUID v7 Sergey Prokhorenko <sergeyprokhorenko@yahoo.com.au>
Re: UUID v7 Nikolay Samokhvalov <nik@postgres.ai>
Re: UUID v7 "Andrey M. Borodin" <x4mmm@yandex-team.ru>
Re: UUID v7 Sergey Prokhorenko <sergeyprokhorenko@yahoo.com.au>
Re: UUID v7 Przemysław Sztoch <przemyslaw@sztoch.pl>
Re: UUID v7 Aleksander Alekseev <aleksander@timescale.com>
Re: UUID v7 Sergey Prokhorenko <sergeyprokhorenko@yahoo.com.au>
Re: UUID v7 "Andrey M. Borodin" <x4mmm@yandex-team.ru>
Re: UUID v7 Sergey Prokhorenko <sergeyprokhorenko@yahoo.com.au>
Re: UUID v7 Jelte Fennema-Nio <postgres@jeltef.nl>
Re: UUID v7 "Andrey M. Borodin" <x4mmm@yandex-team.ru>
Re: UUID v7 Sergey Prokhorenko <sergeyprokhorenko@yahoo.com.au>
Re: UUID v7 "Andrey M. Borodin" <x4mmm@yandex-team.ru>
Re: UUID v7 Junwang Zhao <zhjwpku@gmail.com>
Re: UUID v7 "Andrey M. Borodin" <x4mmm@yandex-team.ru>
Re: UUID v7 Peter Eisentraut <peter@eisentraut.org>
Re: UUID v7 "Andrey M. Borodin" <x4mmm@yandex-team.ru>
Re: UUID v7 "Andrey M. Borodin" <x4mmm@yandex-team.ru>
Re: UUID v7 Aleksander Alekseev <aleksander@timescale.com>
Re: UUID v7 Jelte Fennema-Nio <postgres@jeltef.nl>
Re: UUID v7 "Andrey M. Borodin" <x4mmm@yandex-team.ru>
Re: UUID v7 Jelte Fennema-Nio <postgres@jeltef.nl>
Re: UUID v7 Sergey Prokhorenko <sergeyprokhorenko@yahoo.com.au>
Re: UUID v7 Jelte Fennema-Nio <postgres@jeltef.nl>
Re: UUID v7 Michael Paquier <michael@paquier.xyz>
Re: UUID v7 "Andrey M. Borodin" <x4mmm@yandex-team.ru>
Re: UUID v7 Michael Paquier <michael@paquier.xyz>
Re: UUID v7 Jelte Fennema-Nio <postgres@jeltef.nl>
Re: UUID v7 "Andrey M. Borodin" <x4mmm@yandex-team.ru>
Re: UUID v7 Sergey Prokhorenko <sergeyprokhorenko@yahoo.com.au>
Re: UUID v7 Michael Paquier <michael@paquier.xyz>
Re: UUID v7 "Andrey M. Borodin" <x4mmm@yandex-team.ru>
Re: UUID v7 "Andrey M. Borodin" <x4mmm@yandex-team.ru>
Re: UUID v7 "Andrey M. Borodin" <x4mmm@yandex-team.ru>
Re: UUID v7 Sergey Prokhorenko <sergeyprokhorenko@yahoo.com.au>
Re: UUID v7 "Andrey M. Borodin" <x4mmm@yandex-team.ru>
Re: UUID v7 "Andrey M. Borodin" <x4mmm@yandex-team.ru>
Re: UUID v7 Masahiko Sawada <sawada.mshk@gmail.com>
Re: UUID v7 "Andrey M. Borodin" <x4mmm@yandex-team.ru>
Re: UUID v7 Peter Eisentraut <peter@eisentraut.org>
Re: UUID v7 "Andrey M. Borodin" <x4mmm@yandex-team.ru>
Re: UUID v7 Peter Eisentraut <peter@eisentraut.org>
Re: UUID v7 "Andrey M. Borodin" <x4mmm@yandex-team.ru>
Re: UUID v7 Aleksander Alekseev <aleksander@timescale.com>
Re: UUID v7 "Andrey M. Borodin" <x4mmm@yandex-team.ru>
Re: UUID v7 Peter Eisentraut <peter@eisentraut.org>
Re: UUID v7 "Andrey M. Borodin" <x4mmm@yandex-team.ru>
Re: UUID v7 Peter Eisentraut <peter@eisentraut.org>
Re: UUID v7 "Andrey M. Borodin" <x4mmm@yandex-team.ru>
Re: UUID v7 Peter Eisentraut <peter@eisentraut.org>
Re: UUID v7 "Andrey M. Borodin" <x4mmm@yandex-team.ru>
Re: UUID v7 Sergey Prokhorenko <sergeyprokhorenko@yahoo.com.au>
Re: UUID v7 Sergey Prokhorenko <sergeyprokhorenko@yahoo.com.au>
Re: UUID v7 Jelte Fennema-Nio <postgres@jeltef.nl>
Re: UUID v7 Junwang Zhao <zhjwpku@gmail.com>
Re: UUID v7 Aleksander Alekseev <aleksander@timescale.com>
Re: UUID v7 Jelte Fennema-Nio <postgres@jeltef.nl>
Re: UUID v7 Nikolay Samokhvalov <nik@postgres.ai>
Re: UUID v7 Nikolay Samokhvalov <nikolay@samokhvalov.com>
Re: UUID v7 Aleksander Alekseev <aleksander@timescale.com>
Re: UUID v7 Aleksander Alekseev <aleksander@timescale.com>
Re: UUID v7 "Andrey M. Borodin" <x4mmm@yandex-team.ru>
Re: UUID v7 Aleksander Alekseev <aleksander@timescale.com>
Re: UUID v7 Aleksander Alekseev <aleksander@timescale.com>
Re: UUID v7 "Andrey M. Borodin" <x4mmm@yandex-team.ru>
Re: UUID v7 Aleksander Alekseev <aleksander@timescale.com>
Re: UUID v7 Sergey Prokhorenko <sergeyprokhorenko@yahoo.com.au>
Re: UUID v7 "Andrey M. Borodin" <x4mmm@yandex-team.ru>
Re: UUID v7 Aleksander Alekseev <aleksander@timescale.com>
Re: UUID v7 "Andrey M. Borodin" <x4mmm@yandex-team.ru>
Re: UUID v7 Marcos Pegoraro <marcos@f10.com.br>
Re: UUID v7 Andrey Borodin <x4mmm@yandex-team.ru>
Re: UUID v7 Marcos Pegoraro <marcos@f10.com.br>
Re: UUID v7 Jelte Fennema-Nio <postgres@jeltef.nl>
Re: UUID v7 Aleksander Alekseev <aleksander@timescale.com>
Re: UUID v7 Sergey Prokhorenko <sergeyprokhorenko@yahoo.com.au>
Re: UUID v7 Przemysław Sztoch <przemyslaw@sztoch.pl>
Re: UUID v7 Przemysław Sztoch <przemyslaw@sztoch.pl>
Re: UUID v7 Aleksander Alekseev <aleksander@timescale.com>
RE: UUID v7 "Kyzer Davis (kydavis)" <kydavis@cisco.com>
So I am in the process of reviewing the patch and hopefully can provide something there soon. However I want to address in the mean time the question of timestamp functions. I know that is outside the scope of this patch but I would be in favor of adding them generally, not just as an extension but eventually into core. I understand (and generally agree with) the logic of not generally extracting timestamps from UUIDs or other such field,s but there are cases where it is really, really helpful to be able to do. In particular when you are troubleshooting misbehavior, all information you can get is helpful. And so extracting all of the subfields can be helpful. The problem with putting this in an extension is that this is mostly useful when debugging systems (particularly larger distributed systems) and so the chances of it hitting a critical mass enough to be supported by all major cloud vendors is effectively zero. So I am not asking for this to be included in this patch but I am saying I would love to see these sort of things contributed at some point to core.
В списке pgsql-hackers по дате отправления