Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rSlAU-00Fk4k-Es for pgsql-hackers@arkaria.postgresql.org; Wed, 24 Jan 2024 21:52:23 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rSlAT-008wEH-DG for pgsql-hackers@arkaria.postgresql.org; Wed, 24 Jan 2024 21:52:21 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rSlAS-008wE9-Up for pgsql-hackers@lists.postgresql.org; Wed, 24 Jan 2024 21:52:21 +0000 Received: from sonic310-48.consmr.mail.gq1.yahoo.com ([98.137.69.174]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rSlAP-003C7A-QX for pgsql-hackers@postgresql.org; Wed, 24 Jan 2024 21:52:19 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com.au; s=s2048; t=1706133136; bh=jHqGJMp7ecAVvUPu5C+pQzKqWFCUI6NasGu4kmATbig=; h=Date:From:To:Cc:In-Reply-To:References:Subject:From:Subject:Reply-To; b=cf3PADHDuRRNCqIlwiNxNLKGdCKE3pdd+OLKj7cBLTsRKn88yjVAsdBBdvNhi5GL7XNuktV4VwXm5cGRhyJyQAbCuEagNQDr2NCQbxw8QzaNl2v5TeMhPSAIjZ9qxk2Xc9YyJEEJaxO51+1l2EvIR/uj8OK6ca0gS9Y+f0lihog26ml8hy/c5TqdLRoOE29N04Aw/NYGCl9Kcw11KD80Rx/NQfmUC8pjufrzZoAyJ7C8SOc2Ac8HtDtSuboK8pt+vao6hi7P+8Dj93CABP0Ge0+6LjutBfrVholYldYuCSmXZkQ4UqO5fXYihgDcvpsTQcpRRv2fPPozlgHKa3BqWQ== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1706133136; bh=84pzHZtXnyvM9EQJN0FBG1MZJYOvMn/oRvE2YvOYYW0=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=VvkJ23PBnyyt59T4XWg7T8eScYFXeALs341nFzJpmNbRjgmI0bVD/2eQUe0zMvFfnNl7oJ8CZqYBvZiZMq3VeA04g0o44JVvgAVaMtky4g8qy9b7DtkQTFi+tDoC/1nKjZalCSvfxBj57F6gSmHtmhIpbh+PqBa732eSvJIaHiCUGqbkbNRyLyeu/HdkdrfrkHNOW27LI1/b5u67nt8a9X/G7+mqSpxXhEZtJD6B3A0JLbUE44mbQ8Kqw7keq/AC+OccFXjU+k4jo6PYwcPjQGmNEMx9GCp7Xn+ZUgSJeOYHFW6tO/DKplMclbek/EoM4y0b0p/guJ8OfysOXfvu9g== X-YMail-OSG: tFI4Ij8VM1lzNVFwHYKk_0wnhkMVLJPg2CYU11z0av1w39L9zEwT353vgy5f1KG i8AMh89WMlXuD3L8FHhcqSyJYyJ4h90kH5kYrC2YYpXGhvFy6U7rAarhqVBwcno7n5hz5KJod5ot OeG8YGeIUZyPkj0_86C.l.GeK.ts82RDtQOyRri15l.PlAkvrrPtcRNwzuo1lPQimjwATlMVCCsr RsBfE4QwR_IsmLFNTMVt.NLBhgxPsU2OoG5NvCJzJkDDwatJsyRG7QEnl9Z8FULeyxAXCb3qrjk5 30RzIs.rK5H2RDz_sZOK_bKFjlVuiNoKHJX1SlM5Iqjsqa0GcpAJlhWxGiji0cD226s5Eg_57OgE sxRCXJy_Ag6sx4TLCVupII9JUbLa.bZB6frVWupoktKBKsmC.3EbNqvw1qbxuFBaQBMtriDngtWs j_FElbpx5s8ZkoGWZucn0AvebneWTrYfHLW7BMSbwuAWZQflUpM4it66eTUq1bFm1awNHxnW7YCy Xpp5yq_WDOjyBnrCIj7phE12sewvPZgj8j69nLUvMlG4UgafMiCfhhpzz24cCfwtI9yHQbljxwv7 UHsD02M2o_xgba8D8VYJc1ffdRH3CA4yn9qWOi0Xk.z536VfpPyqt_wHGVm5Vm7RjEKWGkmRd8hL Xxz9fmuzCsfCtA7ki0hwu97f_kWQqDro5T_MxsG8gmX1hiqF3TyuwNjYIpitvlAKRkIaucV0pJxD AQjjhUpHbYmexJX36RjgzQGeKcHklcWCp5FuLLQR5uut4xPfpHXzkvLqiV2Ja051at_KN0j1mS4b ZdkjvP.SA5LGLTlLbSRtjCcQMqAiarZ0fYiXS_ORgjcN5V_x6iyO0n.CjPSEnJDJGwDIymx2mg.1 _V9Tnv9e4pMJ8gLKJ2wZ8T5CvHKsM5LCVRa2MlAB3LbcryqHfWg0LzrVg95x8e4ez7T_9ReMEWAC OXGrikQmMwDibCcWVecsgd1y01VkxkqIyXs4dSKKUUaHv0TRrzh9yZY0uwUeC9qelnnpQnqC9wxS LriDRY_Ug_KMITNuZJsk197IrmoCB8A8E4eng7rQRe1nEMom5CqgAmv1EaYI_t32Y5CsPAthhZAD DhYBeomE_VINVuN.Fx5cXThucKUsJoJ796mwyzlzQbnQ4xEwQSC3nbr1q5.hlJ9z1MfJRcQoOiKX mO3QroFccsEBlS_eDHIVvKVA0levF4SROLCbAl_1HFql9BFOoImUuKyxMRHo1A_FZYjv.De97psw LhjHDoI5c789DTWlmAUw9Alv5cHr2KEgiH6_lZ_S_FKOdkMaDAZb0AcoG10RkD5Bs9c8NkVG_4Cj 9K8kZ9MNHJGmUPVHKCCmkKs3.XkEAl9cnhMppvzzo3Ag7c4g9BZ2GyK_Nw4BtScC7hXia8AW0poa qqg513pVGpWooMjY7QxSXQt_EhjG8WhYGlhz4hEbcAyOscaHGyQEo7OmYvA97Vz35LmsFPm9Tk69 ONGMcnqQ9zVF6YVKceLnAF1fBk8bPiJ2QV8P0kGOKqdePEa5mDN2KWNIoSEZm10BYNIixqwVtbfU f_JKgaH_wyMXxdPsaUZrda1LhpwzQRU9xSIU1_iTAfF7RsisVu18TfGxfADHw84UvPE5N.KNmZyj 5uwlMHZyJrTC_jFxgHCOkPdDBoFh6_17HzxzpX6As9btV3NXy_BlhJeZlY.038Z3BhuDDIQcrdD4 RhLNsRF1MmMAjcFl7eZKbZg0GovuYu7hr.aEsgebWUutKfO6NJNh3RX20ZfNrd5KrEVee9CJRc5f iakPmwJutuN.LU8Bof65fvxUZjof_Rfrwk9IzKHomS7g70NIl8d3YycDgrEryQ5gBDA1UbPg3lnZ jaw0dD6P6S7s8URWsZ33Dg8aQtYJFPVwnabcmHF5an1wCxbE8S3d08utZxAmE5Ke_VuT94mtHqPR tdanpzV5x6VtOWKYKP4wXb6IqCt1wk7YVdmeUYMgT6VIhV8Fe59D1pkIyXaCHkg68KSVUzdUd4QF 9qc8xGPy5UE_oNX9BJNCW2ExBP0Hzj7173TQ5hJ01nzc26X4RZAoUyxc8A4nsFLQHyiOUkxMtIet GyawCHPHDSnhc5LeDqS5jpBsLgPxg4mtuP9KM6apwmyIqEiSEjsLviEIlb2rbPTVkZ4WUDCbfG6F At1_5f_mXFUphhollZoYXtTwOKOYcYUCvqbskB7JnNfM.dCiihVJ4wu5zsRnMVDi3L_2gAHW7_hW F2hy5pQtULMutSzAf8CF7jrzBHqab2NdKJMNe3kE8chgPPsH6mIcnBYMNg0vaphXWCqr8I0Vs0Dd dfVrUZWxauOuEF05qYjn0 X-Sonic-MF: X-Sonic-ID: 929951f1-8e03-4636-a412-5bb9df0d3962 Received: from sonic.gate.mail.ne1.yahoo.com by sonic310.consmr.mail.gq1.yahoo.com with HTTP; Wed, 24 Jan 2024 21:52:16 +0000 Date: Wed, 24 Jan 2024 21:49:45 +0000 (UTC) From: Sergey Prokhorenko To: Andrey Borodin , Nikolay Samokhvalov Cc: "David G. Johnston" , Aleksander Alekseev , pgsql-hackers mailing list , =?UTF-8?Q?Przemys=C5=82aw_Sztoch?= , Jelte Fennema-Nio , Nick Babadzhanian , Mat Arye , Peter Eisentraut , Tom Lane , Daniel Gustafsson , Matthias van de Meent , Nikolay Samokhvalov , "Kyzer Davis (kydavis)" , Andres Freund , "brad@peabody.io" , Kirk Wolak Message-ID: <1459150585.359059.1706132985954@mail.yahoo.com> In-Reply-To: References: <3BDCCF0B-9C96-416C-87F6-071ABD7AED8B@yandex-team.ru> <3E7F8826-A275-44B6-A374-6E35B3B60AD5@yandex-team.ru> <6941A45B-C7D4-414B-A3A9-ACED172DFBD5@yandex-team.ru> <8DB43887-CA09-4845-83C0-33E8A79D0711@yandex-team.ru> <1003561938.6914482.1704452267331@mail.yahoo.com> <80E8F728-FC9C-461E-9B61-332E3AAEC066@yandex-team.ru> <67eb8a02-f35c-af10-1615-afae0f9f7548@sztoch.pl> <8A52AED1-2CA6-403C-8B5B-D24EA8D58616@yandex-team.ru> <9CE1E513-B11A-4C59-980E-D61EC56716E7@yandex-team.ru> <0A0D7507-C434-46AC-BCC4-1166C5A2742A@yandex-team.ru> Subject: Re: UUID v7 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_359058_580608085.1706132985952" X-Mailer: WebService/1.1.22046 YMailNorrin Content-Length: 6178 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_359058_580608085.1706132985952 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable That's right! There is no point in waiting for the official approval of the= new RFC, which obviously will not change anything. I have been a contribut= or to this RFC for several years, and I can testify that every aspect imagi= nable has been thoroughly researched and agreed upon. Nothing new will defi= nitely appear in the new RFC. Sergey Prokhorenkosergeyprokhorenko@yahoo.com.au=20 On Monday, 22 January 2024 at 07:22:32 am GMT+3, Nikolay Samokhvalov wrote: =20 =20 On Fri, Jan 19, 2024 at 10:07=E2=80=AFAM Andrey Borodin wrote: > On 19 Jan 2024, at 13:25, Andrey Borodin wrote: >=20 > Also, I've added some documentation on all functions. Here's v12. Changes: 1. Documentation improvements 2. Code comments 3. Better commit message and reviews list Thank you, Andrey! I have just checked v12 =E2=80=93 cleanly applied to HEA= D, and functions work well. I especially like that fact that we keep uuid_e= xtract_time(..) here =E2=80=93 this is a great thing to have for time-based= partitioning, and in many cases we will be able to decide not to have a cr= eation column timestamp (e.g., "created_at") at all, saving 8 bytes. The docs and comments look great too. Overall, the patch looks mature enough. It would be great to have it in pg1= 7. Yes, the RFC is not fully finalized yet, but it's very close. And many l= ibraries are already including implementation of UUIDv7 =E2=80=93 here are = some examples: - https://www.npmjs.com/package/uuidv7 - https://crates.io/crates/uuidv7 - https://github.com/google/uuid/pull/139 Nik =20 ------=_Part_359058_580608085.1706132985952 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
That's right! There is no po= int in waiting for the official approval of the new RFC, which obviously wi= ll not change anything. I have been a contribu= tor to this RFC for several years, and I can testify that every aspect = imaginable has been thoroughly researched and agreed upon. Not= hing new will definitely appear in the new RFC.


Sergey Prokhorenko
sergeyprokhorenko@yahoo.com.au


=20
=20
On Monday, 22 January 2024 at 07:22:32 am GMT+3, Nikola= y Samokhvalov <nik@postgres.ai> wrote:


On Fri, Jan 19, 2024 at 10:07=E2= =80=AFAM Andrey Borodin <x4mmm@yandex-team.ru> wro= te:


> On 19 Jan 2024, at 13:25, Andrey Borodin <x4mmm@yand= ex-team.ru> wrote:
>
> Also, I've added some documentation on all functions.

Here's v12. Changes:
1. Documentation improvements
2. Code comments
3. Better commit message and reviews list


Thank you, Andrey! I have just check= ed v12 =E2=80=93 cleanly applied to HEAD, and functions work well. I especi= ally like that fact that we keep uuid_extract_time(..) here =E2=80=93 this = is a great thing to have for time-based partitioning, and in many cases we = will be able to decide not to have a creation column timestamp (e.g., "crea= ted_at") at all, saving 8 bytes.

Th= e docs and comments look great too.

Overall, the patch looks mature enough. It would be great to have it in pg= 17. Yes, the RFC is not fully finalized yet, but it's very close. And many = libraries are already including implementation of UUIDv7 =E2=80=93 here are= some examples:

- https://w= ww.npmjs.com/package/uuidv7
- htt= ps://crates.io/crates/uuidv7
- https://github.com/google/uuid/pull/139

Nik
------=_Part_359058_580608085.1706132985952--