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 1qIu64-0002Pm-Ra for pgsql-hackers@arkaria.postgresql.org; Mon, 10 Jul 2023 16:50:48 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qIu62-0007sU-VL for pgsql-hackers@arkaria.postgresql.org; Mon, 10 Jul 2023 16:50:46 +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 1qIu62-0007sJ-KW for pgsql-hackers@lists.postgresql.org; Mon, 10 Jul 2023 16:50:46 +0000 Received: from mail-wr1-x435.google.com ([2a00:1450:4864:20::435]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qIu5z-003JMe-Gc for pgsql-hackers@postgresql.org; Mon, 10 Jul 2023 16:50:45 +0000 Received: by mail-wr1-x435.google.com with SMTP id ffacd0b85a97d-31434226a2eso5583313f8f.1 for ; Mon, 10 Jul 2023 09:50:42 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; t=1689007841; x=1691599841; h=content-transfer-encoding:in-reply-to:from:references:cc:to :content-language:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=OrKEVdRkchB616L/Eoh+b6HpdaEK//M5aA7PxGSZlDU=; b=QNp62yh/AejXgwdnP08Z875iQ4J7S0KrP+eZUYDOXX/LrPOYlHcM0kzEuB5QPm/af5 zqoGF7fxc1zYAqhjW3vSSrc0doMfVnfyGpfK9xl6RSqoT1uHvYQISrW8mLN2xddoBNFj +V/LrYIl8uLLw7Ebye2vezMtAVKByZGv92YbyLqgLpiFMKyFhmHf+87EfNereUMVTG6q z8YCbz/n0hAWz681R8cAObiAyy3cNG+4oxvmCMjNIHOaZ+4RCAbHQl4QghlJqW99EM2Q fIv1nyeNVMViQQwlXqH9cEcSq7b7xpVBPRhf07saGGGXFv8So5A+RQX+znh+hCR5lEo+ aQlg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1689007841; x=1691599841; h=content-transfer-encoding:in-reply-to:from:references:cc:to :content-language:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=OrKEVdRkchB616L/Eoh+b6HpdaEK//M5aA7PxGSZlDU=; b=aohNnlqeljQc1uhiXb36LcyldBdC+zq9SRVyrQNaK58CdU1irnCry3sH0WqCeKDLFc cNkx/DxI3Rc3fKsBxQ0Hv9g26MmNUCbjqOPTKyr9eV4474FEtw61TkdFnqyR4I4Hu5Cx ayg+jExQX5iAYZJxwuTF8zU3EevIwfTacKyw2m3Ae2jtMSS5UbwMkYdZgDXjd3HKUx1w NFfjMp3VWaRn+sQ7eUBcjTsdWwlc2nVo3bxoacCVzD02j3gLIGzGpbp5XRxO+uTOI284 DSVggOTb64kAJXCYNqmdTCCfxQkR+Et9f/mLRk9KFlN7dMIOj1UDh62jAjBSLaILsObn aiXQ== X-Gm-Message-State: ABy/qLaI90LGSMLda0nyO2EvRS79qroLk4UsCY8t/jOlMVxB9Z6RltkH iIzmU+2akcHAcrRH7+tMrEd18A== X-Google-Smtp-Source: APBJJlFHmOolIsEDlSBzkt2Euml7DasQZJm+O7xpJVz9Rud0eCn9dRXI/ojnwWbyFCAYnRybNUnr7w== X-Received: by 2002:a5d:6705:0:b0:313:e98b:7de2 with SMTP id o5-20020a5d6705000000b00313e98b7de2mr15821887wru.0.1689007841061; Mon, 10 Jul 2023 09:50:41 -0700 (PDT) Received: from ?IPV6:2003:c2:7749:b210:1847:9e5:8bd0:bd3e? (p200300c27749b210184709e58bd0bd3e.dip0.t-ipconnect.de. [2003:c2:7749:b210:1847:9e5:8bd0:bd3e]) by smtp.gmail.com with ESMTPSA id l7-20020a5d4807000000b003143aa0ca8asm12139472wrq.13.2023.07.10.09.50.39 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 10 Jul 2023 09:50:40 -0700 (PDT) Message-ID: <5dc6fdaa-5896-ebc4-7094-eac45a818846@enterprisedb.com> Date: Mon, 10 Jul 2023 18:50:38 +0200 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:102.0) Gecko/20100101 Thunderbird/102.13.0 Subject: Re: UUID v7 Content-Language: en-US To: "Andrey M. Borodin" Cc: Tom Lane , Daniel Gustafsson , Matthias van de Meent , Nikolay Samokhvalov , "Kyzer Davis (kydavis)" , Andres Freund , Andrey Borodin , PostgreSQL Hackers , "brad@peabody.io" , "wolakk@gmail.com" References: <20230211011453.uq2yopunpbovcbnn@awork3.anarazel.de> <5ceb7394-7488-d438-0951-fcc940feb539@enterprisedb.com> <5176A0E4-CA75-47D0-A1F3-FBC9B6116595@yesql.se> <7AC9F1D2-A02B-4FF6-A331-C686C7EA244B@yesql.se> <1204013.1688652164@sss.pgh.pa.us> <457ba532-ea71-dc13-6d60-2b79bb32eeeb@enterprisedb.com> From: Peter Eisentraut In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 07.07.23 14:06, Andrey M. Borodin wrote: > Also, I think we should discuss UUID v8. UUID version 8 provides an RFC-compatible format for experimental or vendor-specific use cases. Revision 1 of IETF draft contained interesting code for v8: almost similar to v7, but with fields for "node ID" and "rolling sequence number". > I think this is reasonable approach, thus I attach implementation of UUID v8 per [0]. I suggest we keep this thread to v7, which has pretty straightforward semantics for PostgreSQL. v8 by definition has many possible implementations, so you're going to have to make pretty strong arguments that yours is the best and only one, if you are going to claim the gen_uuid_v8 function name.