Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Zf9sQ-0007PE-Nu for pgsql-hackers@arkaria.postgresql.org; Thu, 24 Sep 2015 17:00:10 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1Zf9sQ-000415-9Q for pgsql-hackers@arkaria.postgresql.org; Thu, 24 Sep 2015 17:00:10 +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) (envelope-from ) id 1Zf9r6-0001Yl-GR for pgsql-hackers@postgresql.org; Thu, 24 Sep 2015 16:58:48 +0000 Received: from mail-wi0-f181.google.com ([209.85.212.181]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1Zf9r4-000152-2g for pgsql-hackers@postgresql.org; Thu, 24 Sep 2015 16:58:47 +0000 Received: by wicgb1 with SMTP id gb1so258681876wic.1 for ; Thu, 24 Sep 2015 09:58:44 -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=JjY/wpAQEEb0jFgY7UnssQGBnae2c3itvhO4e81H7qM=; b=AW8IsH9payY+KEB+zPhiGyQJ5BuxX71kO6IcJWe3EflMvOo339Vhjb8gxpNoKyeS91 edEPBCb+k340D1iZ3HL/mL0TFfTNtXBcGY1qHDc9PkaWP83G+tq24ITmZotxMEhkr2Ls PuAOJR4qO31T6HzwWj/Jt5k50jI4WbYKDY1S6roX0huirEdS5SM3aNN2QXOVjLOlh3bY yJRlWAwECwjCZ9GNgQMJK5xW9NRjtkv9c3jZmkQgBayCO4Fov1Uc8JAfdhxgQC/nyob8 wv6zBtjjdR90eK2BH9wjdTBYlEfD+5AuypDIGQgpKZycxeQtpdPMvTWNdbyau4HnT7f6 kJ8w== X-Gm-Message-State: ALoCoQl4t+1O8FcfN1nptj+NHmdmf/haiLkxWNNSsUasvAtrNyp/YSzH4WwYJZZ4Jq4htOiNBzRH X-Received: by 10.194.236.200 with SMTP id uw8mr770823wjc.126.1443113924346; Thu, 24 Sep 2015 09:58:44 -0700 (PDT) Received: from [10.137.2.12] (ip-78-45-216-26.net.upcbroadband.cz. [78.45.216.26]) by smtp.gmail.com with ESMTPSA id h8sm14469413wib.21.2015.09.24.09.58.43 (version=TLSv1.2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Thu, 24 Sep 2015 09:58:43 -0700 (PDT) Message-ID: <56042BC2.6030201@2ndquadrant.com> Date: Thu, 24 Sep 2015 18:58:42 +0200 From: Tomas Vondra User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:31.0) Gecko/20100101 Thunderbird/31.7.0 MIME-Version: 1.0 To: Josh Berkus , pgsql-hackers CC: Jeff Janes , Stephen Frost , Kyotaro HORIGUCHI Subject: Re: multivariate statistics / patch v7 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> <5519E9B2.5080105@2ndquadrant.com> <20150428161310.GR30322@tamriel.snowman.net> <553FCE56.2000008@2ndquadrant.com> <554A73A6.2060603@2ndquadrant.com> <55638982.40904@2ndquadrant.com> <56042827.6080602@agliodbs.com> In-Reply-To: <56042827.6080602@agliodbs.com> Content-Type: text/plain; charset=utf-8; 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 Hi, On 09/24/2015 06:43 PM, Josh Berkus wrote: > Tomas, > >> attached is v7 of the multivariate stats patch. The main improvement is >> major refactoring of the clausesel.c portion - splitting the awfully >> long spaghetti-style functions into smaller pieces, making it much more >> understandable etc. > > So presumably v7 handles varlena attributes as well, yes? I have a > destruction test case for correlated column stats, so I'd like to test > your patch on it. Yes, it should handle varlena OK. Let me know if you need help with that, and I'd like to hear feedback - whether it fixed your test case or not, etc. 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