PostgreSQLのuuid型はUUIDv7も格納できる。さらに主キーとして使う場合、Bツリーの特性もあり完全ランダムなUUIDv4よりもUUIDv7の方がINSERTは高速になる。わいわい / “PostgreSQL and UUID as primary key” https://t.co/aD2st5HBS1
— matsuu (@matsuu) July 6, 2024
UUIDv7 in 20 languages, check out the Dart version:
— Marco Napoli (@JediPixels) June 15, 2024
UUIDv7 is a 128-bit unique identifier like it's older siblings, such as the widely used UUIDv4. But unlike v4, UUIDv7 is time-sortable with 1 ms precision. https://t.co/hijbBZ37vO #flutter #flutterdev #dart pic.twitter.com/5EwuShrweS
UUID Wars: Many interesting details I didn't delve into. For example: index size reduction w uuidv7, slightly higher TPS w bigint, buffer cache contents vs usage counts during data loads. BIGINT is still a winner but uuidv7 is worth getting excited about. https://t.co/ks91U7EeyC https://t.co/oUHGVm2PBW pic.twitter.com/Xka91h6EU2
— Jeremy Schneider (@jer_s) February 4, 2024
Finally! Time-ordered UUIDs that will fix the DB index locality issue. Hello UUIDv7 (final review stages)! Good bye (?) ksuid and ulid https://t.co/LoJUbrpPZ8
— Francois-Guillaume Ribreau (@FGRibreau) October 10, 2023
0 件のコメント:
コメントを投稿