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 1pNipj-0000ZW-6F for pgsql-general@arkaria.postgresql.org; Thu, 02 Feb 2023 23:17:35 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pNipi-0005hI-2f for pgsql-general@arkaria.postgresql.org; Thu, 02 Feb 2023 23:17:34 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pNiph-0005h4-Lv for pgsql-general@lists.postgresql.org; Thu, 02 Feb 2023 23:17:33 +0000 Received: from mail-oa1-x34.google.com ([2001:4860:4864:20::34]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1pNipf-0004DG-G4 for pgsql-general@lists.postgresql.org; Thu, 02 Feb 2023 23:17:32 +0000 Received: by mail-oa1-x34.google.com with SMTP id 586e51a60fabf-16346330067so4673715fac.3 for ; Thu, 02 Feb 2023 15:17:31 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=content-transfer-encoding:in-reply-to:from:references:to :content-language:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=55CMk7jXS/q2MC/fNwyvO89rpw96xmD1XMxgHjjB378=; b=IvXPUubxUjmCYQGjiNzMg54mjqmSSpei/+oc8Krn0lnVI2pBGGxlnLcc0PWasewt28 XW6x62cEo+4S2V8BUEnJbhhPiSM9O0OyZ+9peHbXL1duvtJ4Ev4wPsyGIfBAqAsoC9/W gW3oXeELSueG0G+Q88FOo4ZQ3aihuBgSV/XF+b2EZPqxEwJz5Py6p3WZ2dz51KCZIUnx zvrYO+UhLOlF1ubcRZk5MqgBx8i7B7aeHxtzrRgpC4wahj2RI43Rwlfo39I57Gs6N3/R w4Q7TxsdXI3P/mMKEzoPM+cxFEmKK70UlymSYFAzXdZdzm517BFgBs7a0i7eUDHPifCM wK5w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=content-transfer-encoding:in-reply-to:from:references: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=55CMk7jXS/q2MC/fNwyvO89rpw96xmD1XMxgHjjB378=; b=yKriWrgmNIuwJcw7WWfWYfRNHszW8fJBDuWzPG6kKt3uGG6Qvuz5nBiShVgM6a4RUN WkyQafthDkeVhvak41vT45vJd3yYA8mqiwGzAMoZqQkmcUJQoCIWc22V/2N0ZKDrHxhW ADio6GequkSKNkbo5SrA7F7RdX5849Auj6XKiyZQV8dHpcKBchv3GQFcfzcUe1iU8Uvh uDFnlQ7Wh0jesLkNNH5LVxi86M7yyaFbFnBqBrmeMSuxTKZwWcpkCAipG7H0guWM/Pw6 VFBOhg+6yooOKsowBt1tKy+cbpRSXmJDiqklZnCdTcxj5W72Fur/PLc7F/Z1u31EBwTm Mq8A== X-Gm-Message-State: AO0yUKX/Slvs5/7HruY531lovAiF1NnRmUyhK2uJayikr9ZtxKUBF2lk nXO7ry8s4bcJAJz7LhVM0zf0UjoxXS4= X-Google-Smtp-Source: AK7set9i+V6zsGx/0poDHGu2eklycUAHNnICK0vuZHqXGOdT7mZprOvOmjOvTIuAgTIs2KA/vOlg8g== X-Received: by 2002:a05:6870:8a10:b0:15f:b92e:337c with SMTP id p16-20020a0568708a1000b0015fb92e337cmr4873351oaq.2.1675379850501; Thu, 02 Feb 2023 15:17:30 -0800 (PST) Received: from ?IPV6:2600:1700:bd2c:b810::43? ([2600:1700:bd2c:b810::43]) by smtp.googlemail.com with ESMTPSA id g37-20020a05683030a500b00684e4d974e6sm409127ots.24.2023.02.02.15.17.29 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Thu, 02 Feb 2023 15:17:30 -0800 (PST) Message-ID: <0893d958-8d71-782a-c1c8-e07746d53fba@gmail.com> Date: Thu, 2 Feb 2023 17:17:29 -0600 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.4.2 Subject: Re: Sequence vs UUID Content-Language: en-US To: pgsql-general@lists.postgresql.org References: <497565.1675097323@sss.pgh.pa.us> <5e551f33-10c3-fd26-67eb-12a22a1da278@aklaver.com> <20230202231120.wzfnigoanuszl2wf@hjp.at> From: Ron In-Reply-To: <20230202231120.wzfnigoanuszl2wf@hjp.at> 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 2/2/23 17:11, Peter J. Holzer wrote: > On 2023-02-02 10:22:09 -0500, Benedict Holland wrote: >> Well... until two processes generate an identical UUID. That happened to me >> several times. > How did that happen? Pure software implementation with non-random seed? > Hardware with insufficient entropy source? Poorly implemented algorithm? -- Born in Arizona, moved to Babylonia.