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 1j4sBo-0004mc-6f for pgsql-admin@arkaria.postgresql.org; Thu, 20 Feb 2020 20:12:52 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1j4sBl-00032P-Rj for pgsql-admin@arkaria.postgresql.org; Thu, 20 Feb 2020 20:12:49 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1j4oR2-0005e6-5D for pgsql-admin@lists.postgresql.org; Thu, 20 Feb 2020 16:12:20 +0000 Received: from mailout.easymail.ca ([64.68.200.34]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1j4oQv-0007Yf-Ha for pgsql-admin@postgresql.org; Thu, 20 Feb 2020 16:12:18 +0000 Received: from localhost (localhost [127.0.0.1]) by mailout.easymail.ca (Postfix) with ESMTP id AB181A00A8 for ; Thu, 20 Feb 2020 16:12:11 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at emo05-pco.easydns.vpn Received: from mailout.easymail.ca ([127.0.0.1]) by localhost (emo05-pco.easydns.vpn [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id RD1oqNMqqaVC for ; Thu, 20 Feb 2020 16:12:11 +0000 (UTC) Received: from [192.168.2.127] (unknown [8.39.228.117]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by mailout.easymail.ca (Postfix) with ESMTPSA id 084BAA0061 for ; Thu, 20 Feb 2020 16:12:10 +0000 (UTC) From: Scott Ribe Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable Mime-Version: 1.0 (Mac OS X Mail 13.0 \(3608.60.0.2.5\)) Subject: benchmarking proposed config Message-Id: <1E6E0384-D13F-419E-ABC9-7BC52B001A68@killerbytes.com> Date: Thu, 20 Feb 2020 09:12:09 -0700 To: pgsql-admin X-Mailer: Apple Mail (2.3608.60.0.2.5) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Does anyone have suggestions for a utility that would easily let us = mirror all queries to a "shadow" PG cluster, so that we can compare = performance of our current production config against a new proposed = config with our actual production traffic? (We could live with the new one falling behind as long as queries were = queued not lost--in fact we know this will happen.) -- Scott Ribe scott_ribe@elevated-dev.com https://www.linkedin.com/in/scottribe/