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 1rnfY7-00ERU4-2P for pgsql-hackers@arkaria.postgresql.org; Fri, 22 Mar 2024 14:07:11 +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 1rnfY4-003uUE-Uz for pgsql-hackers@arkaria.postgresql.org; Fri, 22 Mar 2024 14:07:09 +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 1rnfY4-003uU6-I8 for pgsql-hackers@lists.postgresql.org; Fri, 22 Mar 2024 14:07:09 +0000 Received: from sonic317-20.consmr.mail.gq1.yahoo.com ([98.137.66.146]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rnfY1-005ukW-F0 for pgsql-hackers@postgresql.org; Fri, 22 Mar 2024 14:07:08 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com.au; s=s2048; t=1711116422; bh=aCuI24T3G1YtR2A2l2IhcYvjK+RxzejRHttNbBjXnOE=; h=Date:From:To:Cc:In-Reply-To:References:Subject:From:Subject:Reply-To; b=WsOnhSL1cF7lNBofqFRLW92itC5armztNgULZs+tUtLYkKG5Gwb1/2psirCRBO8OFqSxDLW+mGdLkMPEOQgadlq9c0uxQX6zSvYXBtapvlvUmyISM09Gc2uHj91wFUY8V7cLwghjuvu4qsJ/2tEVACxmKhCuX0LblAGJTrBgDIVRm8qVruuJqdNuM0H/+7y98cIOuvSrlr/9GJVzq+3cJ53+pWE9cnDBEspHf3UHNJWrv+zWJNw+XSNow1BaOrLNgYNhBeNGL2XsCXfIKiKLJBzLMoWlZv9IUhHN3KpAye6rT8UG+Ww7Cqx9MB56UlCoIioGl1CsEukfy0tJaZLYTQ== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1711116422; bh=SVj/IwjVCOR6nw4IZgP1bju8EV53pWldAY8dBHg4BqO=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=iFn21eies1Dw6EnrMS+T/XQA0lo5wva3ePkcLnKmCIk2LVWOOgmak9iZu9LVrCGy9pDvIBO05YYSqvw3I8GhDnCyyI6RjgTyC5llQSBiYTvcFIbVxChidEZDa+tg43pjqfcoecvfXqnxb0RWy0fRFKTZnybJb9fvNO54g9UenLKJh/FE7Uq+TfcqaIsqz67rdkJaIEOgjhZljFyvdDYQzTmACt4SB643Ta4sSPzVUXtob5AdK24sVhMPOshJ6vTBW7P1XLfRDgDw2IONLOE52z8P/4/k1jn66jxfF6mb5Xvhv41gikNDUrZsFkaQIIXylIqSxYVuHs/s9lW6G2H1aA== X-YMail-OSG: qCVYBdUVM1l2ZumLq45H5bE7kPrD7agxXdieCzqhxgs8pfUtQuRppKZqYxOuQy4 IX_kMTNThujsrsUdUl1P6P4tjzYYQcQtLabA9eo.1hDamQMzWLUUgV9eLOcCWzd9Oa5V4IE.YP4Q GyoLQ0Jq759TxnQS70_p_PTfJNTKaqUoELU5a3gXuJmhynoW_iRCuwSibvzH0bBwGJr6NOMZQcuM b.p9iwSJcdlRevdBfN_BKQQo.xKNUQjkbsAeeapykBR.5PkRsbpWJsQQpgdkTnLmSWSAnfwEto.R ZGn5fwDGSszGyUljB0sMSgM3AkE1lApLsO1NpAJBQ5eFd_25MOT1YFJZ7Oz6pykMsUm1cs3qg1Wu rclW8WnAB_wSEr_22zL8s2tBgb54aFmV9.LboRTO12Etm0YjkCHaci69LvXeabW8ANa9503Ngsar og3F2f2LhOTcwKteKRp_Q201lQq2SBH4hr2loqSlno2WkhbtoZ7El8VtHPKRJ7zAqFsvXo9oe5AF WBwz_6W.GnKulZDXL_Dys8fGkVZYwcUqUZGBw9xuQ1kh1VHb2kDoChCtBj5DPZn50WSXPLbyXFCo pVN7KS4Rnl2YMBJUVeyw.hullzSr9EkIZGWcQf61S22faEvWqYMWq0grwYZD5ONDyYp1tZHEvFYO lGnMska44rFF8LHekh29gWScf.DmUYejUx4hUolYeL5k5Lshlqh1ASTRmk57oVQAZ0Kqh1IMi.zY bGE9bPXW0c.J6115q6DQ8LvQfJEZ1oaEirLZX0x3oScaQW5mxesWbZnyT_bZzSsz_GMOpEAjP1.t SH5oMRXp8.6yIPPygCuXcYYxfi95FWBJI.bhF23gezU.NWAi0Q073IGOUZR5qavpZA2SdvUoYwDK 27uS1HNwC6qmFrMZ9y0TPKs3MID7mWqkT3rd9hITFLToADtOKbKbbUadMPbH1jeTkzE7bNfQCC0s 2PRX0ZO3Yq8ECwxvx9IPZ2dSrjH4EmeEfFstPi0NBJyPh5NNvLvkh5avZFhfCS9TqWSV7jLkZQ6Y 6Nj1NobZr8.3bXX0rXl.8Ze2uJ7QCJHp2IfhB_uft38OMjv_h9fzuFbO.tnyQRLTZ52UFSheN5Ky Zk_ACzmW0RCteA33X.7qYJrnZulN1w8T8WQLQcd3a7vDzG64xMJGOwQBnx00amfwk9M69uVKMY1o hxJIx6xUFN4TpfnGHxlcIIqXr7k_Ay.Ykpp1cv4nuNvGaxnsyb5nokacQtDFRXCJGE4ZMYZQnwnf RUshN9F6IMU_ocsnJVC.BMjJX.VLqXjMcJ_GRHoQVHWn_6K74j6F7W3Zsg93FbmMdQx0J0GzB68a 7emWds.TiJq0rFdJlKxMeEsCksyhY.Y34Qs57KPRPlp7vk528vtf3NmrnbD1hjzxXg2K.oILezq3 esDCOubs8vcfrPQv.I8BGmJJXro6uoKe8xZ9pmdLBPoqQnC83.4WstQcOkMkNJK0P0forSzL9Cg. nXMh6A7sjOkybCEjLHC_bmJDrezsCvOXZ3fagezH1YMSrXSfnvIn_C4BypZaUtaD3vKomiBsRWvb TdxgmAHETBY6noGGJoKhNCTM0xlgIjXHumsooXqnnNmBwddU5xnZ251sDl7JHy_vqVO.hwOaU7Ps pwTEcm5u28Yn.78Df3NrpivCsiRnTwUuy6rOcYjkhhOIQ99KObiGWVPgMOP5Q.xetExJTE3vn5.t dr7mdB2HvdnfAtzJFarwwCMIY7Ou7HYaMdjE5sqLb89c8eU3jXpW.i3f46Cn04UQ9aIb40wLTYSd DOr42_j9hnVNK6GsIQfki.2u05tTfPJkewSAnFEghBb82DQyP5jyS5KY.DoAwV7hS8l9_2FXxyND wBRKK_c5wMYeT6njSae_u4WwLeIwT30Y7MPWuy7wBHJ_h5tsgOfSbZtwEwMnc00b4LM8z78Bcnya lnASlfGeLG48ANTt0F93VK7_.M2LOZ4zBpeo3NIcVjeb96xqVdhgmvMNXLpml9qbC6LgrwYJhNlJ 2tbnvicCA_GgzN1G4E1vGI9a0vADM9Ve7oxQjcuLvo6eSUheOSsiGXx336rv_nOENxl.kMAJzuTg bHNVTyO9q6ZYHh9.Mq7doNrJYJeoM5nUEgbRR1QPLmYD5Pcv3dEsr7qrgp20qcUTFyHZL1zLxiwU YkEueZXYTqNkaCPNrD0Hn.MgT2nEJsjK.LP.oJJLh9RKL8YjGQ2y.qIucdcjqr1nlnFG7Csii3Mc Spoli791cTyKwFId6yf.PA9.u5nevjX5C.fAPUq1qJpFDi_6wYoJoetTpNg1usA0qLTnLgisdIPy l.wrqB7IgCM8aWhxewzLLHf5eqVtt2mJvG0ChAQy.Ko5Vn7fZHJKm2V0f1YvBR1pTh2RtL0dWS.o aXLgczQSi8Ds6EhTVShU7BaUM8L0fZibkiAlJJh1OckVDEy4NKKg5c4vBROd9qVl2R2Yh3wf2gwu G0t0SXtzTkxtmFtCQtijXSINq3ICSL9Edb_3A8YMJ7lIVJWQ3v_1kjC8nxvVTQ8oEiLHdTPrYcND HvcLN71NArdHl4sNiIvIRq4nDoyZFu8rET9bVg8Xjz0hFWD_FWBUK8qXdZWWdEMtn6g71_zew75h pLvxs5TOs8HO1Hw.wUigN8HlO0ukaUyNDCOLQ2DrkB43fu1hikyy8m6zCIuMWiaL2m0W7b.Z1prE b53jHNgR90_VGhEkln4LvS6DbGWrOlmiMZQU2EBSPXvQaGww- X-Sonic-MF: X-Sonic-ID: 73b46e3c-b6f0-4a04-9a71-11ac568df48c Received: from sonic.gate.mail.ne1.yahoo.com by sonic317.consmr.mail.gq1.yahoo.com with HTTP; Fri, 22 Mar 2024 14:07:02 +0000 Date: Fri, 22 Mar 2024 14:06:57 +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: <1252872697.212478.1711116417899@mail.yahoo.com> In-Reply-To: <252684972.194362.1711115939224@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> <252684972.194362.1711115939224@mail.yahoo.com> Subject: Re: UUID v7 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_212477_1318984090.1711116417896" X-Mailer: WebService/1.1.22205 YMailNorrin Content-Length: 19266 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_212477_1318984090.1711116417896 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Another source:=C2=A0Microservices Pattern: Database per service |=20 |=20 |=20 | | | | | |=20 | |=20 Microservices Pattern: Database per service A service's database is private to that service | | | Sergey Prokhorenko sergeyprokhorenko@yahoo.com.au=20 On Friday, 22 March 2024 at 04:58:59 pm GMT+3, Sergey Prokhorenko wrote: =20 =20 BTW:=C2=A0Each microservice should have its own database to ensure data is= olation and independence, enabling better scalability and fault tolerance Source:=C2=A0Microservices Pattern: Shared database |=20 |=20 | |=20 Microservices 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_212477_1318984090.1711116417896 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable


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


=20 =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 Wed, 20 Mar 2024 at 19:08, An= drey M. Borodin <x4mmm@yandex-team.ru> wrote:
>> Timer-based bits contribute to global sortability. B= ut the real timers we have are not even millisecond adjusted. We can hope f= or ~few ms variation in one datacenter or in presence of atomic clocks.
>
> I think the main benefit of usi= ng microseconds would not be
> sortability between ser= vers, but sortability between backends.


There is that, and there are also multiple backend workers for on= e session.


------=_Part_212477_1318984090.1711116417896--