Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gmi8i-0005Jh-3A for pgsql-hackers@arkaria.postgresql.org; Thu, 24 Jan 2019 16:46:04 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gmi8g-00044g-G7 for pgsql-hackers@arkaria.postgresql.org; Thu, 24 Jan 2019 16:46:02 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gmi8g-00042D-7k for pgsql-hackers@lists.postgresql.org; Thu, 24 Jan 2019 16:46:02 +0000 Received: from mail-qt1-x843.google.com ([2607:f8b0:4864:20::843]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gmi8X-0001j2-UO for pgsql-hackers@lists.postgresql.org; Thu, 24 Jan 2019 16:46:00 +0000 Received: by mail-qt1-x843.google.com with SMTP id p17so7340193qtl.5 for ; Thu, 24 Jan 2019 08:45:53 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623; h=date:from:to:cc:subject:message-id:mime-version:content-disposition :content-transfer-encoding:in-reply-to:user-agent; bh=J4twL1CIRQDBP7k6EOobXy5glxywXFEnnN3NHBDEoEo=; b=GxnP/jEBJcM8TdF1YQBw3+0QPDQ4PxfhXmnzBwkZhry2fi1++m3oA1YkzuFm/lOFJx VvRS1gbcczBxI3fV8g2g9kidxNAGT4zozzZAQpt9l/y7rmIzBeF7Z5I7ioJpnGB/5NNX w8iXSndPdXqrMmvPBQIG5V/4L5YVbUxA7CchvyI76NEic4kK7NCmOh/XdEq4yrvypEC/ Kt8fwMidiUGIjG08dtbXgbEiq3/abR/G9FmiTpMAtt7Io4VnTrs7B95CJqaK2D9SRUJm 9M4GHZtnAmpb2FNZ1n5wVJZ4Cl+zOTEvErvDXNJFGBnTfsl/0u4gAYitA6TIBGshXcRA bxZg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:date:from:to:cc:subject:message-id:mime-version :content-disposition:content-transfer-encoding:in-reply-to :user-agent; bh=J4twL1CIRQDBP7k6EOobXy5glxywXFEnnN3NHBDEoEo=; b=RVqWG/088FRYlPv68fmfYEJEJUoVCt7R2A6tl8nQWn+zTJxTG5lzBKRGwhySpjQzAh s7XXq8WQtcRenWvjV4zifr6dCZPmS2hqLOjXUFzC/Fpg4zp9CBi4Bc914laIPEq8XCy9 J+HCBTdlLEqY69r0pemzuj9Cg8Z7gNGoHyJTo1znYBwkrjEy5ZBu1baRDFz4pgFtlC35 lZwMrcYySm+vSEmd9PREqvTiYyjdE/i8siu47cTRKXN959qmM0iF4m+ymliPOv7xMv+D EhxlTw/+Ow7V3dfgcEWlB7esdcyHkgA0bDRbeU9jRhEbaJ+tPiUWkQ2EGIN6oRDHWRjx zc9Q== X-Gm-Message-State: AJcUukcmXHiDhp7XTKlqZfnjKkQfyOr84Mp/gNCji1gHKW0l4QETSU0X o+dPQSke+e220dNCYLYeHyXVTJu8X3o= X-Google-Smtp-Source: ALg8bN7C/eYW0X59/+O98xhba7DiJmCZZT5F2Sbubr5CzY0EACoiCJ0YZn+JVyoajPAT9ZKrzomDCw== X-Received: by 2002:ac8:4654:: with SMTP id f20mr7574978qto.274.1548348352145; Thu, 24 Jan 2019 08:45:52 -0800 (PST) Received: from alvin.alvh.no-ip.org ([190.121.29.3]) by smtp.gmail.com with ESMTPSA id g19sm33905884qke.2.2019.01.24.08.45.51 (version=TLS1_2 cipher=ECDHE-RSA-CHACHA20-POLY1305 bits=256/256); Thu, 24 Jan 2019 08:45:51 -0800 (PST) Received: by alvin.alvh.no-ip.org (Postfix, from userid 1000) id 799D1AB4; Thu, 24 Jan 2019 13:45:49 -0300 (-03) Date: Thu, 24 Jan 2019 13:45:49 -0300 From: Alvaro Herrera To: Tom Lane Cc: Fabien COELHO , PostgreSQL Developers Subject: Re: PSA: we lack TAP test coverage on NetBSD and OpenBSD Message-ID: <201901241645.e5syn5lxjldb@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <11057.1548347725@sss.pgh.pa.us> User-Agent: NeoMutt/20180716-1013-2c1e88 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 2019-Jan-24, Tom Lane wrote: > > Also, as > > the pseudo-random state is fully controlled, seeded test results are > > deterministic so the expected value can be fully checked. > > I found that the "expected value" was different in v11 than HEAD, > which surprised me. It looks like the reason is that HEAD sets up > more/different RandomStates from the same seed than v11 did. Not > sure if it's a good thing for this behavior to change across versions. The rationale behind this was that some internal uses of random numbers messed up the determinism of user-invoked random functions; 409231919443 commit message says While at it, use separate random state for thread administratrivia such as deciding which script to run, how long to delay for throttling, or whether to log a message when sampling; this not only makes these tasks independent of each other, but makes the actual thread run deterministic. -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services