Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1etlHP-000804-PY for pgsql-hackers@arkaria.postgresql.org; Thu, 08 Mar 2018 02:27:39 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1etlHO-0007jw-NP for pgsql-hackers@arkaria.postgresql.org; Thu, 08 Mar 2018 02:27:38 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1etlHO-0007jn-DF for pgsql-hackers@lists.postgresql.org; Thu, 08 Mar 2018 02:27:38 +0000 Received: from d.mail.sonic.net ([64.142.111.50]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1etlHL-0000FN-S6 for pgsql-hackers@lists.postgresql.org; Thu, 08 Mar 2018 02:27:37 +0000 Received: from engels (162-236-13-58.lightspeed.sntcca.sbcglobal.net [162.236.13.58]) (authenticated bits=0) by d.mail.sonic.net (8.15.1/8.15.1) with ESMTPSA id w282RV77020158 (version=TLSv1.2 cipher=DHE-RSA-AES128-GCM-SHA256 bits=128 verify=NOT); Wed, 7 Mar 2018 18:27:31 -0800 Date: Wed, 7 Mar 2018 18:27:30 -0800 From: David Gould To: Tom Lane Cc: Jeff Janes , PostgreSQL Hackers , Alina Alexeeva , Ullas Lakkur Raghavendra Subject: Re: [patch] BUG #15005: ANALYZE can make pg_class.reltuples inaccurate. Message-ID: <20180307182730.4b83f3be@engels> In-Reply-To: <25115.1520352964@sss.pgh.pa.us> References: <20180117164916.3fdcf2e9@engels> <20180304191918.39e95382@engels> <25115.1520352964@sss.pgh.pa.us> X-Mailer: Claws Mail 3.14.1 (GTK+ 2.24.31; x86_64-pc-linux-gnu) MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Sonic-CAuth: UmFuZG9tSVb6eGinpBoQw6fk2ILE+pAeKa1g2DTjcrd1ZZ/3yUWkqMH8FyRAB42f+pvzBLkEdRZoJzLUED+0BcjLK2Cwi8JO X-Sonic-ID: C;PIC6QHgi6BGtmyAFsE207w== M;SIzoQHgi6BGtmyAFsE207w== X-Spam-Flag: No X-Sonic-Spam-Details: 0.0/5.0 by cerberusd List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Tue, 06 Mar 2018 11:16:04 -0500 Tom Lane wrote: > so that we can decide whether this bug is bad enough to justify > back-patching a behavioral change. I remain concerned that the proposed > fix is too simplistic and will have some unforeseen side-effects, so > I'd really rather just put it in HEAD and let it go through a beta test > cycle before it gets loosed on the world. It happens to us fairly regularly and causes lots of problems. However, I'm agreeable to putting it in head for now, my client can build from source to pick up this patch until that ships, but doesn't want to maintain their own fork forever. That said, if it does get though beta I'd hope we could back-patch at that time. -dg -- David Gould daveg@sonic.net If simplicity worked, the world would be overrun with insects.