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 1odUUf-0002hg-UI for pgsql-hackers@arkaria.postgresql.org; Wed, 28 Sep 2022 10:40:45 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1odUUe-0007Gk-Dl for pgsql-hackers@arkaria.postgresql.org; Wed, 28 Sep 2022 10:40:44 +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 1odUUe-0007EX-2n for pgsql-hackers@lists.postgresql.org; Wed, 28 Sep 2022 10:40:44 +0000 Received: from mout-b-105.mailbox.org ([195.10.208.50]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1odUUa-0005Oa-S7 for pgsql-hackers@lists.postgresql.org; Wed, 28 Sep 2022 10:40:42 +0000 Received: from smtp1.mailbox.org (smtp1.mailbox.org [IPv6:2001:67c:2050:b231:465::1]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange ECDHE (P-384) server-signature RSA-PSS (4096 bits) server-digest SHA256) (No client certificate requested) by mout-b-105.mailbox.org (Postfix) with ESMTPS id 4MctLW1TsSz9tqw; Wed, 28 Sep 2022 12:40:35 +0200 (CEST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aboutsource.net; s=MBO0001; t=1664361635; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references:autocrypt:autocrypt; bh=8gdbxUWLOte8l/5yKIbHhDiXPqHnr0Yfqpn72ukmbbc=; b=PFjozHzb8x/TTJIqpeFzFqosNweI0WKFXd92A1EO9ynSov2yrmx2pROENJxPLWfs+uRKWC OwGQbceRaKtOQbrS4PswByiFBS+GO6t8Vk4Nt1AuDzBfkbiVm0MgDGmiN2irm6i/oLHi6l SLinrzB6uxzKTcSDEr+abZ0H3+r0PyWxhPTGLsYFoCDPPi6/D7Nz30HA0+HqdLnl3LM8Bu drrfjJyDOtEniQn4xfbNFaHftwaQwqBbuuzfGC2JO8VayduGz043qIeaq+NomlMDzTMyvn IHrfzkHIrqdf9Iba0TzDDxj4n0zJ15V+mt+nRkyeN1T6eSZ+0TJ78GdIAP2OKA== Message-ID: <9cd0925c-9839-a136-c21d-87de9e8a3aa4@aboutsource.net> Date: Wed, 28 Sep 2022 12:40:31 +0200 MIME-Version: 1.0 To: Tom Lane Cc: Andres Freund , Fabien COELHO , Dean Rasheed , Robert Haas , Andrew Dunstan , John Naylor , Thomas Munro , PostgreSQL Hackers References: <459f6008-90bc-bc52-6f11-e68570e03ac0@aboutsource.net> <583b6409-df52-86d1-8c0a-ce8e74863ad7@aboutsource.net> <036ba529-1f25-d7b5-c5ad-e6c852d928df@aboutsource.net> <8fabf9e7-3422-58b0-93f6-d0976d4679df@aboutsource.net> <20220922152320.ukx6teo7wa7cuwkv@awork3.anarazel.de> <193caac5-941e-58b8-65e6-351f777ebd25@aboutsource.net> <3502301.1664223385@sss.pgh.pa.us> Content-Language: de-DE From: Martin Kalcher Autocrypt: addr=martin.kalcher@aboutsource.net; keydata= xsFNBFN7yLMBEADooaBxSSKb4tCT6lSiSmgTr9H8JNM2nQhyvMloNeCmVwhKFxhvcK2DmlM8 oi3uI/Jr7iFC9vXtEta2VX7tgwHZ4FPVYnL7ooBqgrORJDbrdRVBJf9F6gdtK8xXfWm1cRTW Km4tL+x49VnRZYmEl5Rvj/lwJ8cFi/UF46D8comQVb921ZthK5XIeSc3G4BPu6oheKzZ4BU1 59SewONtQYb3DEjSlwmAapX1GG6d/FGeZjTyrimyxoTmOCNo5z/TPyaNMsRSdeo6qjEwa+GI +bqFh0h4QQWD9XaNlqB5wZluWg5MgVtXreXQUg8OoILLlKRguyPb4ayJeUA6/v3wkp6XrsF0 W6L0AJtGVHgO/tzDBcI8D9IOcZHO6bDZXbfkrkO02lL91rI+VtkRUBUcAe5dS3RI9O3BNu4s +1AWeAjXy7aMeesBgZjvSCCC7MkIJr6cpVND3lwrqTt9FP5uFYL4ePFpslQ4FUskxc6axg7k rmGakqDNTh/a0oQw2mHLGBgmLnFbpUox46m4ZEwneozg5svKSU3M2LdX/FbBlP+lXJ9aSk33 8cdpq8kEmT+KxyQh6RiapZjwMEvTaicc9LjSMxpgb3/NO2wKxT/xuZIIWhWUW3WKV2iiZ7q0 bkMzQ1V0oKQ+5CQWC/B7q6T3eeds3yrY1RExLckypfPOrpKtgQARAQABzS9NYXJ0aW4gS2Fs Y2hlciA8bWFydGluLmthbGNoZXJAYWJvdXRzb3VyY2UubmV0PsLBeQQTAQIAIwUCU3vIswIb AwcLCQgHAwIBBhUIAgkKCwQWAgMBAh4BAheAAAoJEAp2lpuJy0B7a1MQAK5SIxl+V7vm5wNM wNOwZE8BYKQox94YQ5iQGWW5dLgHpbP0KTrcthdtAq2k3Pk9qmx4/dq/dQww0ofKNFHccTWG KA3OdPIg2l/rhcKBVcy8Zd2FMEPwdQ93PJo5xe6CNatIIyAJTggdWyAm2Jb/lbyqruvZgsNr 9pKFW6/2/Its68MqMz2ciWsj6APNzoRuunsBCIjxmCQIY1B1rRvbS1IsPqo/FBJD3p1fjp8x DcKDoMePQ5wDSc1Af4UYFwq2hZt10A8fAtVwitXrVRjmzWXhvGHX4GNBz75V5vogwh9RQYKh f+N3gAkijsFNn1yik3rnH7WWDYD1h2SjNNzB785VHCKWN+lc4vK4yx1yDHw8g4ALJFpDWfOY JBpSNL51VI2qN+HzBuJeCMy+0LxNjlejbOSvYvS/KwXszjNcF3M0V4LoTb2xTwkXc50GaYIj GhzPnXxIJ1szjh/qbxLkg5kopjr8vUVtDnS/rRDPzAFqDfFOTXuU57xOAayXKz+dfdFkVE6/ SixWd4TS0Zq7YrlnIFldUiYO5koZSWcbS9iednrysepM/JC/2fe5p4PE3tws6LHv856dnGpg 7AhoCH59v8rP6sjvHxFS5t/yJfp+CEKooqte4GlqqashPelUqrBDZqJxaeZ9R8bUESMRkAW6 dOxsQKE7EyoMEjZwf4bNzsFNBFN7yLMBEADMv9v3T00tIFhiy1ck+NsA+4WyvjQ5gzOzwibH /vCkmBwzFwuMtu+/SNL0PpekwCebg1cHmVyHEDLpmOQTdHZHG1QskHfjTIOTW9TDYkdNtn9T o7sNp9dxw3s8RIZZxyvmytPKSoQbQbaNsk4XJxhNPzd1w/fZcG0iVXm5JDa206TC41BPAbuu mH6o+mWZROGsDWCAz3/G2S5pjteRKaSoQ12NodwsqFCC2f97k6w2ErxtUIafE6HYp8NTf6J8 VV/nRkWLwp1G2TAA2+YN5iRAogSOtITXqx0NliQ+yqLVfkx29l618do5Faa6MO1XCyCQi4GF eL7DWn5sr+MWrOsHGQhZctE2mtVt3NHgp77MsBVI32oCdzHwsoxK0Z5TTS38IZ3Z5HfI1ebw gU7zvLodQxwTKhWPhxJY+norUM2tmg+r8DZ6y0RFgJywimh0YEScoLw3nAjJ2Z4vxI8zj4jQ xJzmPuSZVUSceqiY/3wNiohJjaHbbsQyxDhx39o7JKrZomQeyi180IVqqs3o8u9NxgL1Z/yC JZro69YffsVMuk7Ls0lPGOeNj0/tXUzq1bqrL2FFXsKiXovEi06Y/8MYh8xwUtPGlQkToRPj mkZ8FoUysxBjGsftPGyETDfay0r3uOn9mTlIY3BIMtsIdwX96pfrxrr0lbGizriC5senJwAR AQABwsFfBBgBAgAJBQJTe8izAhsMAAoJEAp2lpuJy0B7SnoQAOZ7/ihLJ2PPECcVZI1kxuYP 2bsKy/uBgdQZEvSOJB/HK9KkTvfGrQ7R2aZNl934bFidyBpp00mtIBEU7U32j4KNQmRPMCB+ qTpRHfSlZtwsThOs3pZWreN/p4iTebF3V0MiVAt6kZ+8F/f6bTVVJUtzW1umLZXum0NkSzVH n3hGcpIDmxeDxBmL0bnxnvvoJxk2LSJfWfxWr1Dxp6ney4MiET3MMLLCztWiJ2900dLsGeY0 b0YUZmXQ4ySs2jBZQLWeLepJjlEDArZyQUCc36wKXu8OXm2YbM1k5castYlxNhG5dVAVCAdP RTqiQsMzseQu2Al4kXY/1zjA3rs/ZLZLEJ8CWX/KkmqXb9l8CnyRkgctxU3bmS1dOZsno/5e mpmk0RW3FO6Xc20jK2BAZ2T8g2nxB258zBYTyHrP+ntD8owhQM0ODh2QAHOPHKg5MTtZMxQs +sYqLYY/B+BdPLsr6sIt/3VBy/EvMN1HSVFwRcmTyozkq2M1+HgLqgDe4If3sS+xtSSPjrhh N6GfXd6x1vHPG1yjMm4nqr95QXsK/dflGcRl/ea83cb9H1425Fdpn3US7EPtlE/32LBbyn3k SIefppJxINe8AG/MJQVxHP2eLlttPYPWNhh0Bf7KQjzcQJ81QjNMBS5mCR+2aor89DXXeDDG Xses1a4BHhjP Subject: Re: [PATCH] Introduce array_shuffle() and array_sample() In-Reply-To: <3502301.1664223385@sss.pgh.pa.us> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Rspamd-Queue-Id: 4MctLW1TsSz9tqw List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Am 26.09.22 um 22:16 schrieb Tom Lane: > > With our current PRNG infrastructure it doesn't cost much to have > a separate PRNG for every purpose. I don't object to having > array_shuffle() and array_sample() share one PRNG, but I don't > think it should go much further than that. > Thanks for your thoughts, Tom. I have a couple of questions. Should we introduce a new seed function for the new PRNG state, used by array_shuffle() and array_sample()? What would be a good name? Or should those functions use pg_global_prng_state? Is it safe to assume, that pg_global_prng_state is seeded? Martin