Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eYe3Z-0006jY-0X for pgsql-hackers@arkaria.postgresql.org; Mon, 08 Jan 2018 20:30:05 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eYe3Y-0006w2-CI for pgsql-hackers@arkaria.postgresql.org; Mon, 08 Jan 2018 20:30:04 +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.84_2) (envelope-from ) id 1eYe3Y-0006vh-2A for pgsql-hackers@lists.postgresql.org; Mon, 08 Jan 2018 20:30:04 +0000 Received: from mail-wm0-f66.google.com ([74.125.82.66]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1eYe3V-0000dy-IB for pgsql-hackers@postgresql.org; Mon, 08 Jan 2018 20:30:02 +0000 Received: by mail-wm0-f66.google.com with SMTP id n138so16447690wmg.2 for ; Mon, 08 Jan 2018 12:30:01 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623; h=subject:to:cc:references:from:message-id:date:user-agent :mime-version:in-reply-to:content-language:content-transfer-encoding; bh=lljYq1CF7BmccClpJJFe23j7zHBDuHBhrb/8D3rM/cE=; b=L72/oEF0/6c/w4BjKPpvkWettH1wEraqfCotQ3B+5Z49DkiI/sPRxDS7GhbjDt5SX7 16OHO5F5bicip5vhzrBlB9hUBdvoWdTxbaHkrdvGzYAQI0nk4QpzZf03nc2YzUR/G11V U4BUnxFBjaoi3eZNEFHJccJGCmeo6k3V1u5xCg/TLSVes83TQzEyzH/HMJfbIQeOXWcy jgtWPy/C7FbZCit6qHwcnCgeEHf3z0zaoHz3IjV1ukaA1GyUb1FCXgoLn5A+64v3y7T9 PGfuiWXFufqSKievZklExTy/Y38I8jarj8hOF1fAMCdwUf0jebuWScAm5zmdVDw90uE3 MpxA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:cc:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-language :content-transfer-encoding; bh=lljYq1CF7BmccClpJJFe23j7zHBDuHBhrb/8D3rM/cE=; b=YMhuD0ESlXxzHS4n1EPfh68xWEtin8OeRulVPfQYpVXXmzQOw3LD4Q1Stn+qg3BPGF s71og58lORck+UcEY3Q+cSC34hV3yAJMsI6KlRyMFcmnFv6gJTPQTjGZs8zQ9kkkKYKh g7RW6vmFp1vNN3CtOgD5ashQnObiXHKH1dceP+JmTQHVzxe0lIqcLRH0mvph75K6+zsF UqT82IZHAWz9XIvh7yYs4kzGCI/95RaEvisFZGvLNBwvxEo8ncafziPCUrNjRdb8iAB/ sZNOEJ6Ol0b8yWdtwZ2wc+tTaHbCywRLWOcZ2le5m4rWnAq19NDo4lfgVAFciUWgY8CI zbtA== X-Gm-Message-State: AKGB3mKa3jPWLxJH5X77DauzKomth17wqmFfTYLM0P4Vg5SqmwJah3OM mH8H9LcqEpu64CzEF8O1Vgp7JQ+FdXNsmb4rtX6vg+jAq4lVEArfFaRbBET/kQZULbTaT7c6F2t Lv4AeHsPvVBhk6yfxPw0a7DMvcpR7ZHUNTgKJyH/q/1u2eX7LhzYn7nTG15goyWuJ9rAs3WPuA3 HzGkhnk/+x X-Google-Smtp-Source: ACJfBouM8SZ2qsUIHUW2O5bgkftlDqKp7VEj3wRmtfu5S4IzFpdRJ8kQUp1EVgwg3i3KjPsFQnH53w== X-Received: by 10.28.140.67 with SMTP id o64mr10598515wmd.137.1515443339499; Mon, 08 Jan 2018 12:28:59 -0800 (PST) Received: from [10.137.2.19] (ip-78-102-97-226.net.upcbroadband.cz. [78.102.97.226]) by smtp.gmail.com with ESMTPSA id o2sm10621809wmf.27.2018.01.08.12.28.58 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Mon, 08 Jan 2018 12:28:58 -0800 (PST) Subject: Re: [HACKERS] VACUUM and ANALYZE disagreeing on what reltuples means To: Tom Lane Cc: Stephen Frost , Michael Paquier , Haribabu Kommi , "pgsql-hackers@postgresql.org" References: <16db4468-edfa-830a-f921-39a50498e77e@2ndquadrant.com> <19990.1500936945@sss.pgh.pa.us> <3d250597-384e-c5f4-7533-b513e366888f@2ndquadrant.com> <94f58897-861b-accf-a9f1-af4be816c0d3@2ndquadrant.com> <13097.1509650125@sss.pgh.pa.us> <3dca6a76-fa4b-66ab-c0db-496335d650b1@2ndquadrant.com> <20180105042528.GK2416@tamriel.snowman.net> <1e831867-c46c-8f21-79d4-5de70cac5822@2ndquadrant.com> <13711.1515440364@sss.pgh.pa.us> From: Tomas Vondra Message-ID: <01387f5d-a95b-d159-becb-cf9ff9ba4e41@2ndquadrant.com> Date: Mon, 8 Jan 2018 21:28:55 +0100 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Thunderbird/52.4.0 MIME-Version: 1.0 In-Reply-To: <13711.1515440364@sss.pgh.pa.us> Content-Type: text/plain; charset=utf-8 Content-Language: en-US Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 01/08/2018 08:39 PM, Tom Lane wrote: > Tomas Vondra writes: >> As I already mentioned, Tom's updated patch is better than what I >> posted initially, and I agree with his approach to the remaining >> issues he pointed out. But I somehow assumed that he's already >> looking into that. Tom, do you plan to look into this patch soon, >> or should I? > > No, I thought you were going to run with those ideas. I have a lot > of other stuff on my plate ... > OK, will do. -- Tomas Vondra http://www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services