Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cYb2H-0007Y0-2c for pgsql-hackers@arkaria.postgresql.org; Tue, 31 Jan 2017 16:12:01 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cYb2G-0007tG-Lb for pgsql-hackers@arkaria.postgresql.org; Tue, 31 Jan 2017 16:12:00 +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 1cYb0p-0005Q0-TJ for pgsql-hackers@postgresql.org; Tue, 31 Jan 2017 16:10:32 +0000 Received: from mail-wm0-x229.google.com ([2a00:1450:400c:c09::229]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1cYb0n-0004uy-5o for pgsql-hackers@postgresql.org; Tue, 31 Jan 2017 16:10:30 +0000 Received: by mail-wm0-x229.google.com with SMTP id r141so85735535wmg.1 for ; Tue, 31 Jan 2017 08:10:29 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623; h=subject:to:references:cc:from:message-id:date:user-agent :mime-version:in-reply-to:content-transfer-encoding; bh=aXUqgKrvi0JyYV+Od8mAlqFZ8EJTk9uSXL9nIQAkrw4=; b=ME837BBBYC+/PsbInvuOzlGGRP5wF7ECR3Kk5WP57zy9QCoR/PoF6ojSb/K0EreyYX RELqP5BPokIyFs+Drz0PPR0rOamBc5U5Ueklqg/ajfSXFlvnJJP6RGEz3sLmtX6Y2JH5 r5k3RQfuSuK0//ijSm+hmGcCRTNyJRxK1Qlp3s3ZJ3BodTxNy541/HONNt9Nz50yJM+f VtdB9wXTB3LZ+/Y1ON93fwP5JnCHLbObJCQ6bMHep1FCmc+4i988yKvJA9OtefEVf2vV vvQQF5iJxPo5qxdwxTyNQbxjvkkFgydx8X7rNPMf9NbT1+kqTUYwPjvc0jIUAul0dLNC yF4Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:references:cc:from:message-id:date :user-agent:mime-version:in-reply-to:content-transfer-encoding; bh=aXUqgKrvi0JyYV+Od8mAlqFZ8EJTk9uSXL9nIQAkrw4=; b=nBuxElgwHi3VIQQMadTMXtj8pWpPnkf6hl1guyUaHGbbwHnuheVttzE+QAKKJplIca lMk4w8305xOdetAMYLcbJZljsgnGXvZwj9ojLKEp4yVAdMixapKiUO7H30M3QElHit3x kr55S7YiYoU6myw8W5kanDMDzo0HlnFlO/3krhx181P424w/nKlgrfGPr4klipOZ6pFf ZRkW+6lPjKa3d+123r+1kqXDP+FiRqb2j873CyMjBxocjn06vkqasc7OidvA2hxDTuPi Tw4xXLBcRgClNcC2XmLnn+UPhRWadWcZBlWFE0vunAnALTv3irKxhNbNAS61kh33qIIQ qe5Q== X-Gm-Message-State: AIkVDXIUNEiVa5X3rr49VhdvJTkfDbmtnA3QRMIMKXQFkQ5lpIn8CrL3esmS6Wxhr5f7ljg4CwTVpQys5C/mDFaOSkFJf/iDKcTwJcQfSQwfKsBZYR1qhs5HYb0Hl+E4BVv1ymlCDj0E+4/WZlmWOIC3RWY7D+V9i2Nvm0OGmE7Jbkyf2lhMhskEWsmXGq3srYafUcIgdr52 X-Received: by 10.223.164.66 with SMTP id e2mr24062002wra.47.1485879027756; Tue, 31 Jan 2017 08:10:27 -0800 (PST) Received: from [10.137.2.17] (ip-89-177-46-65.net.upcbroadband.cz. [89.177.46.65]) by smtp.gmail.com with ESMTPSA id y65sm24611652wmb.5.2017.01.31.08.10.26 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Tue, 31 Jan 2017 08:10:27 -0800 (PST) Subject: Re: multivariate statistics (v19) To: Amit Langote , Alvaro Herrera References: <20170130203714.latitwfmrzukgugh@alvherre.pgsql> <3d2c8ff5-89cf-b3cc-3a91-29761046022d@lab.ntt.co.jp> Cc: Dilip Kumar , Dean Rasheed , Heikki Linnakangas , Michael Paquier , Robert Haas , Tatsuo Ishii , David Steele , Tom Lane , Petr Jelinek , Jeff Janes , "pgsql-hackers@postgresql.org" From: Tomas Vondra Message-ID: <2b6afa80-aa4a-0ae2-e558-b5d58cff8cfa@2ndquadrant.com> Date: Tue, 31 Jan 2017 17:10:24 +0100 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:45.0) Gecko/20100101 Thunderbird/45.4.0 MIME-Version: 1.0 In-Reply-To: <3d2c8ff5-89cf-b3cc-3a91-29761046022d@lab.ntt.co.jp> Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org On 01/31/2017 07:52 AM, Amit Langote wrote: > On 2017/01/31 6:57, Tomas Vondra wrote: >> On 01/30/2017 09:37 PM, Alvaro Herrera wrote: >>> Looks good to me. I don't think we need to keep the names very short -- >>> I would propose "standistinct", "stahistogram", "stadependencies". >>> >> >> Yeah, I got annoyed by the short names too. >> >> This however reminds me that perhaps pg_mv_statistic is not the best name. >> I know others proposed pg_statistic_ext (and pg_stats_ext), and while I >> wasn't a big fan initially, I think it's a better name. People generally >> don't know what 'multivariate' means, while 'extended' is better known >> (e.g. because Oracle uses it for similar stuff). >> >> So I think I'll switch to that name too. > > +1 to pg_statistics_ext. Maybe, even pg_statistics_extended, however > being that verbose may not be warranted. > Yeah, I think pg_statistic_extended / pg_stats_extended seems fine. regards -- Tomas Vondra http://www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers