Subject: Re: multivariate statistics (v19)
To: Dilip Kumar <dilipbalaut@gmail.com>
References: <5d1d62a6-6228-188c-e079-c1be59942168@2ndquadrant.com>
 <20160410.023757.532440443943028713.t-ishii@sraoss.co.jp>
 <0924a7a9-a219-1366-d3bc-2ddd98bc9269@2ndquadrant.com>
 <CA+TgmoavDKN1eT-dpx2KatgbyNTYbT4-gVY5j-D190S-odYf4w@mail.gmail.com>
 <CAB7nPqS1obvpYL1_pt6i4XizWZZ96CEo_BOU4yTExr6RWG2TtQ@mail.gmail.com>
 <CAEZATCUtGR+U5+QTwjHhe9rLG2nguEysHQ5NaqcK=VbJ78VQFA@mail.gmail.com>
 <0ce73e37-7be4-8d9f-1ec4-46b0ca1d90c6@2ndquadrant.com>
 <1c7e4e63-769b-f8ce-f245-85ef4f59fcba@iki.fi>
 <CAEZATCV5ZPqvsbJJ77jr4R9beqd=xwVUnMwBkMeCw5zDdrqRNw@mail.gmail.com>
 <9f7d5c73-71d6-fbe0-c190-b321db46f88c@iki.fi>
 <CAEZATCWKEm1VhLdWFF5SPk7yVW0ZzH4MQFTxgDswopOwmVY+cw@mail.gmail.com>
 <277d9678-7a35-a746-0eb5-41d4bcd4ef55@2ndquadrant.com>
 <61e71067-9461-d785-b4a6-6e8a08996d5f@2ndquadrant.com>
 <8508ad05-54b9-f402-e736-e992ea014a32@lab.ntt.co.jp>
 <72eeb3d5-c406-93b0-8ff8-11b31789f683@2ndquadrant.com>
 <CAFiTN-scNndU0BiYUqyM2qvyuNLjWJvJ1=9gdA9SXwvKsw0ELQ@mail.gmail.com>
Cc: Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>,
 Dean Rasheed <dean.a.rasheed@gmail.com>, Heikki Linnakangas
 <hlinnaka@iki.fi>, Michael Paquier <michael.paquier@gmail.com>,
 Robert Haas <robertmhaas@gmail.com>, Tatsuo Ishii <ishii@postgresql.org>,
 David Steele <david@pgmasters.net>, Tom Lane <tgl@sss.pgh.pa.us>,
 =?UTF-8?Q?=c3=81lvaro_Herrera?= <alvherre@2ndquadrant.com>,
 Petr Jelinek <petr@2ndquadrant.com>, Jeff Janes <jeff.janes@gmail.com>,
 "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>
From: Tomas Vondra <tomas.vondra@2ndquadrant.com>
Message-ID: <7c4b2088-5cbd-dfec-0b98-16e5a7db5308@2ndquadrant.com>
Date: Tue, 3 Jan 2017 17:22:48 +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: 
 <CAFiTN-scNndU0BiYUqyM2qvyuNLjWJvJ1=9gdA9SXwvKsw0ELQ@mail.gmail.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-hackers-owner@postgresql.org

On 01/03/2017 02:42 PM, Dilip Kumar wrote:
> On Tue, Dec 13, 2016 at 3:20 AM, Tomas Vondra
> <tomas.vondra@2ndquadrant.com> wrote:
>> attached is v21 of the patch series, rebased to current master (resolving
>> the duplicate OID and a few trivial merge conflicts), and also fixing some
>> of the issues you reported.
>
> I wanted to test the grouping estimation behaviour with TPCH, While
> testing I found some crash so I thought of reporting it.
>
> My setup detail:
> TPCH scale factor : 5
> Applied all the patch for 21 series, and ran below queries.
>
> postgres=# analyze part;
> ANALYZE
> postgres=# CREATE STATISTICS s2  WITH (ndistinct) on (p_brand, p_type,
> p_size) from part;
> CREATE STATISTICS
> postgres=# analyze part;
> server closed the connection unexpectedly
> This probably means the server terminated abnormally
> before or while processing the request.
> The connection to the server was lost. Attempting reset: Failed.
>
> I think it should be easily reproducible, in case it's not I can send
> call stack or core dump.
>

Thanks for the report. It was trivial to reproduce and it turned out to 
be a fairly simple bug. Will send a new version of the patch soon.

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