Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tiIq0-00EBr3-Lb for pgsql-hackers@arkaria.postgresql.org; Wed, 12 Feb 2025 19:56:00 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tiIpy-00DQOl-IL for pgsql-hackers@arkaria.postgresql.org; Wed, 12 Feb 2025 19:55:59 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tiIpy-00DQOb-8Z for pgsql-hackers@lists.postgresql.org; Wed, 12 Feb 2025 19:55:58 +0000 Received: from mail-wm1-x332.google.com ([2a00:1450:4864:20::332]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tiIpx-000SSe-0F for pgsql-hackers@lists.postgresql.org; Wed, 12 Feb 2025 19:55:57 +0000 Received: by mail-wm1-x332.google.com with SMTP id 5b1f17b1804b1-4395560cc13so1075955e9.3 for ; Wed, 12 Feb 2025 11:55:56 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1739390156; x=1739994956; darn=lists.postgresql.org; h=content-transfer-encoding:in-reply-to:from:content-language :references:cc:to:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=JnsoFI/IN3d7rEkBdizlcf8xHq/2uVA5LMi7hj7MrNA=; b=ccPPZf3n4dNB6hpufk4n90fnM74BFpQG8p4KOM6jaudFCseK/ehufPZPHYGK/VBENP FllcRo8LZrahelKeRceu4MP4/5LLDYcsHQgT17fcpyl1tefJq/bnrieTQbPbEQtlMV1J 2/PunaASxu/SSEJE3wAwTWn0+W+d4h1as9wOI7F0hFLvukh7b8Y2yWfcqa2DrHVdS0BM sghy+6NxGhZM9Cni/X6NysSSMN917/jFQWuC9mywpy/4dCI66D0MBOyQuHmZ3XGFKEDs m0XwLUD9/vjlVIOsFIFpvKCJom3XK/8j9UcdVRLAfPShg0F/dueuca/WHM9eCSF6YYxf xlow== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1739390156; x=1739994956; h=content-transfer-encoding:in-reply-to:from:content-language :references:cc:to:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=JnsoFI/IN3d7rEkBdizlcf8xHq/2uVA5LMi7hj7MrNA=; b=BdyUu0Qg1dRPXvoKI6I5C8D1uTjG5wdo/KbXL10nxBnBcnu9FVP7a6K3/yzbPTK/d8 FMD6cDsKCuNzvuz3q1K6nRF1aL/s1TOOCmB2i9lQdlsLh/oq/k2FWJ0NWYwYnhh2VIAT AOw9S8YREWDqzfVuL8/UozCPGyUBSCAbRLT48i1D0egkPCXRGl85GUZUKBwNT4Vnpqh7 jt7DBp1hmgyimc+yl9dfmux7ymEbZD3Km/yNO0NV1Iwe+SUyZj7yuq++pH6qRkDnh7cQ VUkWmCcAzgMRBnk8zvg0zBSqDa+WFqlGoZ+txScXzNpXLGr/UoohSBc8PqUjiuDiJZEi 7/aQ== X-Forwarded-Encrypted: i=1; AJvYcCVgH0FlcBsyb3plSsLpwIK3uvH8OB5XNjlIHxLgEkpZj3fzKY+iTucczxyYoqYEXLdIsr0mIKZLaLSAGkXy@lists.postgresql.org X-Gm-Message-State: AOJu0YybNEDu4folTUapBuGZO6esQyy7NyT+QaUbApNiL+/29u5DKGvq 0KB32OyMG9DIsbCRCSpZszO7y+BGWmYQpYp/1U1pyxgOELI13+AB X-Gm-Gg: ASbGnctPDFILw+7uA25JXGm9eQJHk625hjCuI3PmICMinM/CamG6VXQl/rVGyimrfaN 7w9HduEZrvaMS0Ug4/azxF5UknYnk9wK+cYkNXuVYiiBlb6eZ9JuPDHDtlCLj+ms0HutbpCDdf8 zEeMVOh7lM1rNDKOINjZbFsqdMR5/EobzW0MAJ+oeuEFjSTrKWEJcrS+eFh6Ei2AGqSXJT37h6z xMHjGjf9edgObSB9dhDnTpdmW3QHw7GrAxWcd2YyKu/W3WP2wsYCxfdSkzEdBrdSzQI5nGWnsrP mhGAk3xr7oiB5adspHgi2WEu X-Google-Smtp-Source: AGHT+IFnKOQ9dlcHgaK5O3OYFHSVuIn1ijFo/9rJ7cNMn7MtHKBpdndJSo04u6FBrDBGFplCvM6iFw== X-Received: by 2002:a05:6000:1f8c:b0:38d:eb33:7be6 with SMTP id ffacd0b85a97d-38deb337ca9mr3265712f8f.4.1739390155364; Wed, 12 Feb 2025 11:55:55 -0800 (PST) Received: from [172.20.10.2] ([31.4.241.183]) by smtp.gmail.com with ESMTPSA id ffacd0b85a97d-38dd4c8ca52sm12582599f8f.89.2025.02.12.11.55.53 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Wed, 12 Feb 2025 11:55:54 -0800 (PST) Message-ID: <0e4c813a-18eb-41e2-8edb-89b78d43c82d@gmail.com> Date: Wed, 12 Feb 2025 20:55:53 +0100 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: explain analyze rows=%.0f To: Tom Lane , Robert Haas Cc: Ilia Evdokimov , Matheus Alcantara , Guillaume Lelarge , Daniel Gustafsson , Ibrar Ahmed , "Gregory Stark (as CFM)" , Amit Kapila , Justin Pryzby , Peter Geoghegan , vignesh C , "David G. Johnston" , pgsql-hackers@lists.postgresql.org References: <55695d15-c738-4401-8883-58bc855c9b03@tantorlabs.com> <58bb3a5b-c92a-408c-b02a-f47aedc1c0e2@tantorlabs.com> <70bc1af0-6910-4f71-84ba-fa02095fe9ba@tantorlabs.com> <3212947.1739306803@sss.pgh.pa.us> <3365160.1739385615@sss.pgh.pa.us> Content-Language: en-US From: Andrei Lepikhov In-Reply-To: <3365160.1739385615@sss.pgh.pa.us> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 13/2/2025 01:40, Tom Lane wrote: > I was idly speculating yesterday about letting the Ryu code print > the division result, so that we get a variable number of digits. > Realistically, that'd probably result in many cases in more digits > than anybody wants, so it's not a serious proposal. I'm cool with > the fixed-two-digits approach to start with. Okay, since no one else voted for the meaningful-numbers approach, I would say that fixed size is better than nothing. It may cover some of my practical cases, but unfortunately, not the most problematic ones. -- regards, Andrei Lepikhov