Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YaM0g-0000En-T6 for pgsql-hackers@arkaria.postgresql.org; Tue, 24 Mar 2015 10:24:35 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YaM0g-0006dA-7D for pgsql-hackers@arkaria.postgresql.org; Tue, 24 Mar 2015 10:24:34 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YaM0e-0006d3-Hl for pgsql-hackers@postgresql.org; Tue, 24 Mar 2015 10:24:32 +0000 Received: from mail-wi0-f174.google.com ([209.85.212.174]) by makus.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA1:256) (Exim 4.80) (envelope-from ) id 1YaM0a-00084J-RW for pgsql-hackers@postgresql.org; Tue, 24 Mar 2015 10:24:30 +0000 Received: by wibgn9 with SMTP id gn9so90969259wib.1 for ; Tue, 24 Mar 2015 03:24:26 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:message-id:date:from:user-agent:mime-version:to :cc:subject:references:in-reply-to:content-type :content-transfer-encoding; bh=/bFUhSkoDuAZzgF+thdZwk8t0vdxKjs58wEKuEpBROM=; b=a7bqLwB3vq28K95SHw0U3IdMtk0gZuXRHUpX7h1wpGuZSIARXH9qH/BA1Eas8BFtOy Q00t5EM3OZhR93jXPyBU8eVU/A1Q1MIhViMYkjr/AVJtPCifZ4pTz5Fb13U18skOMdcA IQ5eSXSyEyiN+2HA8ENfpVD1Mz8LtVE3TJPUmWMnRO1L2x6pmray5LvYsVgPGho1cS5p r3kmVEEdX1OQm0Yf/L/Jvc+gjPW04KVczpAS4FZ/4ymwNOL/kI9CTChJuVIgo4I4V714 5oxUQZGMMbVr+lx8gvPu4GpdcwRUyzNVDuUbhqM26o2ZUg7Y31Q1xjic1TtGkZiuU3Dq JudQ== X-Gm-Message-State: ALoCoQnfzV7D/4K3QcebixsJUMbbc1t5fOX2LUsYLUbXY8aBUHRoCAjLrxG8q2B6OaE91foTUHJ1xna2DR8H0eT5yvqP1VYjIHIUBzxvVCAaJ+aO3J1aFdE//wIf2Yygp7y9odM0l5fh8XESJPCOvc1pD/fzPtlgoFztddsfijHQWge4kqQ+CR3OG4F0PlrZmvbi9HFuq4jK X-Received: by 10.194.94.1 with SMTP id cy1mr6193857wjb.127.1427192666386; Tue, 24 Mar 2015 03:24:26 -0700 (PDT) Received: from [10.137.2.12] (ip-78-45-139-138.net.upcbroadband.cz. [78.45.139.138]) by mx.google.com with ESMTPSA id ch6sm5452985wjc.3.2015.03.24.03.24.25 (version=TLSv1.2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Tue, 24 Mar 2015 03:24:25 -0700 (PDT) Message-ID: <55113B55.4040309@2ndquadrant.com> Date: Tue, 24 Mar 2015 11:24:21 +0100 From: Tomas Vondra User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:31.0) Gecko/20100101 Thunderbird/31.5.0 MIME-Version: 1.0 To: Kyotaro HORIGUCHI CC: pgsql-hackers@postgresql.org Subject: Re: WIP: multivariate statistics / proof of concept References: <54C3FED3.1060600@2ndquadrant.com> <20150320.173307.249113775.horiguchi.kyotaro@lab.ntt.co.jp> <550C8E50.2010600@2ndquadrant.com> <20150324.143427.34552953.horiguchi.kyotaro@lab.ntt.co.jp> In-Reply-To: <20150324.143427.34552953.horiguchi.kyotaro@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 Hello, On 03/24/15 06:34, Kyotaro HORIGUCHI wrote: > > Sorry, not shown above, the *previous* t1 had been done "alter table > t1 add statistics (a, b, c)". Removing t1 didn't remove the setting. > reiniting cluster let me do that without error. OK, thanks. My guess is this issue got already fixed in my working copy, but I will double-check that. Admittedly, the management of the stats (e.g. removing stats when the table is dropped) is one of the incomplete parts. You have to delete the rows manually from pg_mv_statistic. -- -- 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