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 1ndzH9-0007Yy-Sv for pgsql-hackers@arkaria.postgresql.org; Mon, 11 Apr 2022 19:00: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 1ndzH8-0007K6-DQ for pgsql-hackers@arkaria.postgresql.org; Mon, 11 Apr 2022 19:00:34 +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 1ndzH8-0007JV-3w for pgsql-hackers@lists.postgresql.org; Mon, 11 Apr 2022 19:00:34 +0000 Received: from wout1-smtp.messagingengine.com ([64.147.123.24]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ndzH5-0004PK-Pc for pgsql-hackers@lists.postgresql.org; Mon, 11 Apr 2022 19:00:33 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.west.internal (Postfix) with ESMTP id 58D6532020F6; Mon, 11 Apr 2022 15:00:28 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute4.internal (MEProxy); Mon, 11 Apr 2022 15:00:28 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ilmari.org; h=cc :cc:content-transfer-encoding:content-type:date:date:from:from :in-reply-to:in-reply-to:message-id:mime-version:references :reply-to:sender:subject:subject:to:to; s=fm2; t=1649703627; x= 1649790027; bh=ztI1OI3VFFqvMyqDlKshhciEX/4+fu+6TIqhj7ft8ko=; b=E OR3H2VDXoDJ1nwJilIEcvjxPf7safvdK1x6KdODJ1udbABpjaiyUDWZa3D0CxqQY ZI1J8qjdYOqF9xJxWjpajR58IttYiLuWyvzC5DdM4w3GiDuP7FaeV9mBFW6K2AHY qGRl4dR/SmYnTWd0YbKpGQrox70aAr7k31dRNFM4kJ/+w/hojiEOBMTvMgy/jbKs ZMquhjBuWaI4+14sMAYrt6CsziYIzjI9DObqx4oA/OcM4M9lrOZAY4P704yVdz63 fE/+BaDJ3SXq5TwOo9WEuEnCkcDu+Au/s4K93tfF6eA/blLFv4HOJO1ZBlEP3KIB c1OUKMczKhni7T90w9Ouw== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:date:date:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:sender:subject :subject:to:to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender :x-sasl-enc; s=fm3; t=1649703627; x=1649790027; bh=ztI1OI3VFFqvM yqDlKshhciEX/4+fu+6TIqhj7ft8ko=; b=H2GaIdeIX2wAgoD+qs2+bV0siwTrD Odrf9NKvUm63t9pua1NuYFD4HBGBFPjcAioVh+41tX7kIkOZZKkEOWCf1NXbqA/F aQ+YkDKsBAe3E0MZtF21QwDy+6dUcgBV2mosdyM2iPRnCjrRkSjJJt8jACMmwYMS tPovyK/qGKLYdVoxl5AnJsM4312hdmsMUbj6Q0Dq8UazNwUdncKNuKLcvT9oHbcb grs2omeGryOvtvyAT0UpzPBWj4b7OWByhsYQzovosxjq+zeNCv2tWPc04DYMSFaq L1CpZsJTMgNU6yyjVr8HULWj+4nWVlcKHeDXiiXJODEjI6fY6vfrl5U2Q== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvvddrudekiedgudefgecutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfgh necuuegrihhlohhuthemuceftddtnecunecujfgurhephffvufhfffgjkfgfgggtgfesth ekredttderjeenucfhrhhomhepffgrghhfihhnnhgpkfhlmhgrrhhipgforghnnhhsnohk vghruceoihhlmhgrrhhisehilhhmrghrihdrohhrgheqnecuggftrfgrthhtvghrnhepve duudduieelfeeileduhfelteeuleefheffkeevjeevhffhffegtdeffedtheffnecuvehl uhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomhepihhlmhgrrhhise hilhhmrghrihdrohhrgh X-ME-Proxy: Received: by mail.messagingengine.com (Postfix) with ESMTPA; Mon, 11 Apr 2022 15:00:27 -0400 (EDT) From: =?utf-8?Q?Dagfinn_Ilmari_Manns=C3=A5ker?= To: Tom Lane Cc: pgsql-hackers@lists.postgresql.org Subject: Re: random() function documentation References: <875ynfpiru.fsf@wibble.ilmari.org> <432790.1649702719@sss.pgh.pa.us> Date: Mon, 11 Apr 2022 20:00:26 +0100 In-Reply-To: <432790.1649702719@sss.pgh.pa.us> (Tom Lane's message of "Mon, 11 Apr 2022 14:45:19 -0400") Message-ID: <8735ijphrp.fsf@wibble.ilmari.org> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/27.1 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Tom Lane writes: > =?utf-8?Q?Dagfinn_Ilmari_Manns=C3=A5ker?= writes: >> I just noticed that the since the random() rewrite¹, the documentation's >> claim² that it "uses a simple linear congruential algorithm" is no >> longer accurate (xoroshiro128** is an xorshift variant, which is a >> linear-feedback shift register algorithm). > >> I don't have a suggestion for the exact wording, since I don't know >> whether xoroshiro128** qualifies as "simple", or to what level of >> specificity we want to document the algorithm. > > How about we just say "uses a linear-feedback shift register algorithm"? That works for me. Nice and simple, and not overly specific. Should we perhaps also add a warning that the same seed is not guaranteed to produce the same sequence across different (major?) versions? > "Simple" is in the eye of the beholder anyway. Indeed. > regards, tom lane - ilmari