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 1rnfQQ-00EQps-Se for pgsql-hackers@arkaria.postgresql.org; Fri, 22 Mar 2024 13:59:15 +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 1rnfQP-003n9e-8p for pgsql-hackers@arkaria.postgresql.org; Fri, 22 Mar 2024 13:59:13 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rnfQO-003n9W-Tw for pgsql-hackers@lists.postgresql.org; Fri, 22 Mar 2024 13:59:13 +0000 Received: from sonic311-23.consmr.mail.gq1.yahoo.com ([98.137.65.204]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rnfQK-005uf2-U9 for pgsql-hackers@postgresql.org; Fri, 22 Mar 2024 13:59:12 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com.au; s=s2048; t=1711115944; bh=C0PBvALUsjl5i/HlwkjWUoODeNJDwVkv0vKvJh7B6p4=; h=Date:From:To:Cc:In-Reply-To:References:Subject:From:Subject:Reply-To; b=ZTUMOUm0pYKswZdyomNQ30ZhoiorjGlSKvD28ZViar1TClYeFTjNMYpp5CjJX5cTUVnk8jwzKsQNK5kkO2lic6MxjeJs4qfWB/y2wJKQOoKecqXZr4AXkb/VIfHHSsgkjbfQK8RB2MszoaGjIXDn0cd4kYePQSAmDf5vaPIUzV6Jr7m4OPeS2F0NjNwGFG4vfq+0+1cqpc9UAo2yyYuG6ok7ySXYP5q/DZe3IO6kDR0qqujVFEb1jFpAwHoB4HSHlevsVOjod12PSL+GhM/TXwXuXoFLW8Wpg1TJtnKWM9q9jP1ITGBD9Sy9DuU9WQTaYlJxBz5NDJqUTALcDJMRKA== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1711115944; bh=6zhKDaIbL73mTuU0+LENErwmXf6tixR4IRY0LONUgpN=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=BDawLdq/uNGplRByGh8d503TuNLJqxwhbqPqI7OoMFUldyGtpsBGBqeBNFogCxbmiQYxVuZhSKTJJau/1jK48lA7biDm0jrIjg+tV1qm8O5a4D6J7i6KoU5wsoi//DEE9+vDJhHourhQfuj8xshZ004Qell+45NdDgVcncZi6CMS9/O6o4G8WX2H7QozOzGT5Hum++ykIXHs6vIGb+rYoA7oKYv07VO+Fxupu0eLasnFYR5w7PTj+4/5qzCb5YM6zDItGUJwP2itj7EW9mTmWDOdogTkFJHs6JzzurYHfd0O/kpeeAMQVThCd4R4EYiSq7/a5gy3lTKmcUJklKpZjw== X-YMail-OSG: 3SwyYHoVM1lsON66AjsJliil6tXNFZzhFTBJExUZwz_7qP9urfDpc6GaLRjpaS_ rK7vrzK9Eaxy5ALv7B49rCu1v3pgCE0T2Pfsj6oT.Ty3eiwKJ7lewVOsycBbRDFelalPZJq8PENW 2LYgI4dNB2T.WysslWFQZ3rX5nT86jWvV_cQskKSA9niLFDvRv0NNxSAo46k3vICvSg18h5Bguzh KOiLjGQNHvPCB5OF1AoKWCZAD._KpisgPlPh.TFFlF3nqjFyvIHwb5y0Gwkzg.ycuyQJufj7d4ai C7WyZ0k.NOXLzm_uR9qRlsT0feEikhB0VywrSJR4tUHujAKYDlDzGGWQECzTah.2VeIM3s3gSh9q jh5KzDvcIWMWEnTiBiTcxzdS13X6b9VZDEXG5YL5_DVzdtvE9LRY_dLzRmi_J2WMDowMN0eCQqzE cefNJ2PHPuxW9RNf2_XB_vonpZPgBGUQ4249H2FNaR_0l931tWvCeQryrxlNXOzI.mve17XvCHDh Gk1mwzBBk5xgOpkO0mpAqgyEcEw_I6_5zwn.TNCBNJGjkr1JKr33MNPbP4hpOFxt6hgky.s5JK3B buKnFViz7uhiSqlWWIWXPGoze11NjaEXxpun91Ci8H9USoVTy4V4__WZM_BxMhtcCEgD0g3WXM8Q YcpD7R2B2dBASBrTARMTkQCaVweKAluXMuniZRe.LJkIHFSTz4Cpa9rzNO.VZqNXavVP4DjRKYdS Ud8a8R7uDmmrHhAcOPtU9zxA2PzN7dyzaNDzw6pmiJzd2wEB7CqtjAsJf9EGHqR9vFvn4rUw00K5 Nf52ImPLIATkpDIpXy6htOJozmWqZ.YutnRw4Fzd7CiRaCsnN8qn7EEEKQ.sJXTEoQ_aW.6dPGNR 0lIVyr82oRqT_ugxWp.6JzuGbOWUVayNhcCit.ieMYU4rpozWHRC4nqVBZCM.u2roZLCtGDpfejI mZ7RtBlXi74Yk4Q.vdfVOL0eeXxCEVdse9K0YFrH.4zc9hWS2fIesoONFkrDmpgHeWD9RVGdLhFF tt.9VCkd4DAB5PGoOmN1sfGH6g6.2nrNs7gqc7yV5Vxf8WkLR7oiSqlRMc2Tpd4QvLhpgw2ww2l1 5Vxk3MGMNhvqUQ62ZLxkpf3rf3xhvFmyTUEPx6ZEuZClbBTZ9DpTf98RRYjh5fmlcRakoP1EuxfF hKCkWUiFDSVsaiLur5aMpMXjwlAJo.LfH7kEac06g532bK2p9bBPxK0knIBoDj8qas95Ecw467rT kea5Z9nAL9jbap5tpOQQuMWG7CzI1.H4e5E_D2Dxzqu2rHXSgHhvAabyjeFmMVK87.MiLvtaox5V Y1Jey2iXJ26gre68fPkVIwBdBA8UXOVYD8ht0YcGbppOxGBxGe2TQXtzPKgq6evJNBawd_noBytD J7iZIQg5ora_ATXgp5z9DM55B3zP1xbFBIjjxXLuVM7u6FWuagUSgUlWh.uos_VH3lsEbNoebzCs FcMkI9GezJrthixriPUrPbTYTDu7AughEfg0aYvOGRwVIPINfNlGIMgrUUpeJwbHY52JvsKn6eLJ 1HMU_Lw3E7tFABOtA89LJ3wFoPz3lTmboia32FqBy_sp5BAJZO0cGiCiw1fUoMSib7PP3udnQiXr bmlXqubUjFXNRJ65b3CfboXv6usxIhhvtohXuYFkDvhGKFniElOVEcNDSHiHtUY8l8d71j38XGjt X6MJOJQZDoP8GUCA.2.o1H_lUsDwg2PyymaNI6DGKF6dIbB6MbcA9To_VeU_101BaaJ7MalkBPlC lBXgJeNfLVIDJIhvvaRW3VmcoBlPh7kqsLDJc0YKuPH4dO4s.zHkXKHzaQ8oUu98V3qE5fPse76w mDXIpOZcFSDdzocyPvGmeX4hrIW55Kgi0DSQLS4R_26VLwCbMdb7M37ZPuGtuqBGCtkuCbcQZcC5 T9WyxO_tUMnpnaC5wqMT0sETSqjeIk54v6c5of.6R2L9Xv5.kKCwE0JHAekAUA1c5wkbryE..haE 126YE7cKAUEBA.1yT5Gd5IWEXeqP_qpr6VbX47aohLRjSXaeNDau7lRBhHh14fOBC_u8pH734Vpb Q108UwyIRbUngjZEalUJYaI6_GGg0Pr1OmIoMmC8Er11RWqNw5Ds7kyaIVVgwzeKBqZFtkxWibmu UM3Lqr6IetpgPL_Juu0_5vd9dc.ygdi6.9_ZsmPC8J49nCtiFQMVaGTyw0fxI4n5nyABIEX4RPdW WGrCfkkwkJDaKxil5o3CwajZ..UwQgHM4wJpTh_6UaRKDHOEw8c6j8EE_S3R3WbZsOzpUomr8YYn uFQo- X-Sonic-MF: X-Sonic-ID: 063a552d-e350-49ed-8e13-638b180e24e3 Received: from sonic.gate.mail.ne1.yahoo.com by sonic311.consmr.mail.gq1.yahoo.com with HTTP; Fri, 22 Mar 2024 13:59:04 +0000 Date: Fri, 22 Mar 2024 13:58:59 +0000 (UTC) From: Sergey Prokhorenko To: Jelte Fennema-Nio , "Andrey M. Borodin" , Peter Eisentraut Cc: Aleksander Alekseev , pgsql-hackers mailing list , =?UTF-8?Q?Przemys=C5=82aw_Sztoch?= , "David G. Johnston" , Mat Arye , Matthias van de Meent , Nikolay Samokhvalov , Junwang Zhao Message-ID: <252684972.194362.1711115939224@mail.yahoo.com> In-Reply-To: <457249376.195310.1711114940632@mail.yahoo.com> References: <8AA22330-7D3A-46CF-B311-2FF874D7C713@yandex-team.ru> <1971811009.2132347.1706599708209@mail.yahoo.com> <72C1E7CB-E2EC-46CF-AD2C-B3180CED885B@yandex-team.ru> <0906F8BA-CA52-4956-AA68-E9193E50DFDF@yandex-team.ru> <10553e4c-6b66-44b9-86a7-80bb1958a767@eisentraut.org> <0C26E3AC-983E-43A4-B39E-270FF87A0464@yandex-team.ru> <0b1b5e91-177e-4362-8caf-d227d5a1ae3c@eisentraut.org> <08ccb447-cce8-491c-a9d4-7f9ac07c0330@eisentraut.org> <457249376.195310.1711114940632@mail.yahoo.com> Subject: Re: UUID v7 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_194361_1126137463.1711115939222" X-Mailer: WebService/1.1.22205 YMailNorrin Content-Length: 9749 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_194361_1126137463.1711115939222 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable BTW:=C2=A0Each microservice should have its own database to ensure data iso= lation and independence, enabling better scalability and fault tolerance Source:=C2=A0Microservices Pattern: Shared database |=20 |=20 | |=20 Microservices Pattern: Shared database | | | Sergey Prokhorenko sergeyprokhorenko@yahoo.com.au=20 On Friday, 22 March 2024 at 04:42:20 pm GMT+3, Sergey Prokhorenko wrote: =20 =20 Why not use a single UUID generator for the database table in this case, s= imilar to autoincrement? Sergey Prokhorenko sergeyprokhorenko@yahoo.com.au=20 On Friday, 22 March 2024 at 03:51:20 pm GMT+3, Peter Eisentraut wrote: =20 =20 On 21.03.24 16:21, Jelte Fennema-Nio wrote: > On Wed, 20 Mar 2024 at 19:08, Andrey M. Borodin wr= ote: >> Timer-based bits contribute to global sortability. But the real timers w= e have are not even millisecond adjusted. We can hope for ~few ms variation= in one datacenter or in presence of atomic clocks. >=20 > I think the main benefit of using microseconds would not be > sortability between servers, but sortability between backends. There is that, and there are also multiple backend workers for one session. =20 ------=_Part_194361_1126137463.1711115939222 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
BTW: Each microservice should have its own database to ensure = data isolation and independence, enabling better scalability and fault tole= rance

Source: Microservices Pattern: Sh= ared database


=


<= /span>

Sergey Prokh= orenko sergeyprokhorenko@yahoo.com.au


=20
=20
On Friday, 22 March 2024 at 04:42:20 pm GMT+3, Serg= ey Prokhorenko <sergeyprokhorenko@yahoo.com.au> wrote:


=20 =20
Why not use a single UUID generator for the= database table in this case, similar to autoincrement?


Sergey Prokhorenko=
sergeyprokhorenko@yahoo.com.au


=20
=20
On Friday, 22 March 2024 at 03:51:20 pm GMT+3, Pete= r Eisentraut <peter@eisentraut.org> wrote:


=20 =20
On 21.03.24 16:21, Jelte Fennema-Nio = wrote:

> On We= d, 20 Mar 2024 at 19:08, Andrey M. Borodin <x4mmm@yandex-= team.ru> wrote:
>> Timer-based bits contribu= te to global sortability. But the real timers we have are not even millisec= ond adjusted. We can hope for ~few ms variation in one datacenter or in pre= sence of atomic clocks.
>
> I th= ink the main benefit of using microseconds would not be
&= gt; sortability between servers, but sortability between backends.

There is that, and there are also multip= le backend workers for one session.
=

------=_Part_194361_1126137463.1711115939222--