Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qCP4o-00006p-GY for pgsql-hackers@arkaria.postgresql.org; Thu, 22 Jun 2023 18:30:38 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qCP4m-0004Ah-UR for pgsql-hackers@arkaria.postgresql.org; Thu, 22 Jun 2023 18:30:36 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qCP4m-0004AH-KZ for pgsql-hackers@lists.postgresql.org; Thu, 22 Jun 2023 18:30:36 +0000 Received: from mail-qk1-x731.google.com ([2607:f8b0:4864:20::731]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qCP4j-00442Z-0I for pgsql-hackers@postgresql.org; Thu, 22 Jun 2023 18:30:35 +0000 Received: by mail-qk1-x731.google.com with SMTP id af79cd13be357-763e968b7feso152323085a.3 for ; Thu, 22 Jun 2023 11:30:32 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1687458631; x=1690050631; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=Wej/7Ft4LI8f0odrPE1wpliyUXyyn/6wpo4DdJqIMqc=; b=jCgEy3KP//vWRXmlz7/eSWcJRdiSQwta+EmK7MUfPHtfzFU98ehO9qWfC4MUwDtlWB ghzyUntlk+PZCfoG1G3ViEaAab/4jfBhhPd8REoADzzF6W3mjkOf+AW4Hx0GYNpE/yl4 i8GWQk5hj9fblWMyS2+7c5Md2kBTloUwcWUkAE7tGvUCZuctMTMQuw4fuoJZXlsfInKp qp05YVUQFSyv8Oe88lDw/8UEUTjmm4/FEkGamQlvqNd7RbsNMs5KvyNEITn1Z0dmS/Fp 0vgtP3grpOz6Zo+au4ID3sYe3vkUJAZFLNPk7JzOVG4ymBRUPzieCGT8kHi+nsUTgNa6 fqag== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1687458631; x=1690050631; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=Wej/7Ft4LI8f0odrPE1wpliyUXyyn/6wpo4DdJqIMqc=; b=iSJ3ZPH5hjWAGdxV9qyXO3wJH8uw7ph0KxvjDvRpADukS2aFEviG8Hw4kvFaSza7dk KDL3mb59hPsKpsaIOSfoqBXDVYZ5IbiMW0dk2asbWH0QXpYmYI7CgEv+E2tx7AeJkFVm tQDQYZcQaqGZsZ5xvWROSqlJKI4/oSdI/Qh0lMffE5KFxmG2vBcUSrmNMVjOWj6Z4zMx H2yJ51uEjWWke9nibF+CiLW02t3qbjIP2+65FbNZQsrifP2Hx2w8sTRJ/wTSwKiCwVLR 5mSC/bVqn6XMPD1x3uSPm3MTBHA5W1e9wA7s1oMp8iFH/vxlxCwPUnWg//+5qAbaOFs9 YGLg== X-Gm-Message-State: AC+VfDxrUBGF5JpnOP7E68eNvNfnPEF1mIXTK3d+p/x6DUqkCkz+RBZF Ym6ZzpwIKPXBGR9bMqryC+ZIL5Qc7BdzMV5tPEw= X-Google-Smtp-Source: ACHHUZ4CZGCU+I+PH064ohNTpXu0Zu+ZMPk49SRoqS0bcpIkvsvgSI2w+br9ZBNGmdwt5Kv2PDPvObIvcHfwbBdapxU= X-Received: by 2002:a05:620a:2953:b0:763:af1f:710a with SMTP id n19-20020a05620a295300b00763af1f710amr11520720qkp.21.1687458631207; Thu, 22 Jun 2023 11:30:31 -0700 (PDT) MIME-Version: 1.0 References: <20230211011453.uq2yopunpbovcbnn@awork3.anarazel.de> <5ceb7394-7488-d438-0951-fcc940feb539@enterprisedb.com> In-Reply-To: From: Nikolay Samokhvalov Date: Thu, 22 Jun 2023 11:30:20 -0700 Message-ID: Subject: Re: UUID v7 To: "Kyzer Davis (kydavis)" Cc: Peter Eisentraut , Andres Freund , Andrey Borodin , pgsql-hackers , "brad@peabody.io" , "wolakk@gmail.com" Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, Feb 14, 2023 at 6:13=E2=80=AFAM Kyzer Davis (kydavis) wrote: > I am happy to see others interested in the improvements provided by UUIDv= 7! Thank you for providing the details! Some small updates as I see them: - there is revision 7 now in https://github.com/ietf-wg-uuidrev/rfc4122bis - noticing that there is no commitfest record, I created one: https://commitfest.postgresql.org/43/4388/ - recent post by Ants Aasma, Cybertec about the downsides of traditional UUID raised a big discussion today on HN: https://news.ycombinator.com/item?id=3D36429986