Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gRPim-0007ur-F4 for pgsql-hackers@arkaria.postgresql.org; Mon, 26 Nov 2018 22:51:16 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gRPil-0004KI-9b for pgsql-hackers@arkaria.postgresql.org; Mon, 26 Nov 2018 22:51:15 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gRPik-0004K5-QM for pgsql-hackers@lists.postgresql.org; Mon, 26 Nov 2018 22:51:15 +0000 Received: from mail-wm1-x342.google.com ([2a00:1450:4864:20::342]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gRPih-0002HS-AM for pgsql-hackers@postgresql.org; Mon, 26 Nov 2018 22:51:13 +0000 Received: by mail-wm1-x342.google.com with SMTP id 125so19985753wmh.0 for ; Mon, 26 Nov 2018 14:51:11 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623; h=subject:to:cc:references:from:message-id:date:user-agent :mime-version:in-reply-to:content-language:content-transfer-encoding; bh=so7Aa6taqJ7AkKX7Hdeh4lyFbYZhUfQylFTZIm14dnw=; b=YDlyfKycwlTy4vXtOWm6R71FerCJqIKizUWJCMxFT8vXpmWhQeknZsC1L5/A3eI6d1 J7Y6jcKtlFDZ+1NG1g2HVeiHeYgNx0ecycM0IJwsz/bamF//oklqU1za+xtV1GBb+sRG u3K72ZX9sBuKXNR4w/sA7AbU6GPd1T6TCPbVs9IjCtkXiDNEawS5f/DBDdw5/UF0BVdz uPvTYKmidVrDJZDZBUmAnCilgju6/18KKDbVSAH0GIy2f1/HZW1AN1PnZBchZ37UirtE bmxXX6XeyJEjr6vcsJ6EayQrUhr4bA8ZeInnUOFsM2MAIBoOSRIzJ9jOSJ/0AYpLHKMA jrrQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:cc:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-language :content-transfer-encoding; bh=so7Aa6taqJ7AkKX7Hdeh4lyFbYZhUfQylFTZIm14dnw=; b=PAvvHYgauSFaGMlEtyftxapG7yrbS0E6nMI0aczSUKfXiJtefWjWUUWP1OvjYbdRT/ XHXdqVX6GX5OWKPauImZYz+U8mYy/9f9rYjaGrmoK/vTUuKcCCYsd6UU6M2gxZJtCMle ATzYA/cFQyjg15PmH3A/CxrB2Qj/joOG5A2cYYFF5bvFLkcCj32p9gUzXhoYWqtk4ad7 c31oT72ReBa2iU98Ueu2k/vMODGV+BL6G8pu1fWVBmxQ64NaAAqBEJvSPadfdkzWdfOD n0DWgy2ZozwqqrddxMJ2zFXeWUNRou5ujlQl5nW/czbiLhc1ADTKVsiDKfF7UcoJebzo mATA== X-Gm-Message-State: AA+aEWZwfDczs5qk95wQbVdZ2IrnBRQwrfHg9tiNHEVEdgMdgzQEYp9+ tn9nSXjv8sdGdW/CSqYt/uK6CcH/SJpkgO3YL5RBU/ubNKHkP9QoZxoJ2k3cEyRE070Xxxz/gP+ 5I6sPfInFY6I0b4ekJWRhlcvgnxeHdsNxv2iONaecu+2OJv9/yuGNXQaxcQJPxoXrD8KZ0BPouS QlAQhdnA2kPG0zFA== X-Google-Smtp-Source: AFSGD/Xpfuaz0nOOnjlWqfcs1H94gysMazSig4TAv2yByo/yz0rTEvlsmxBZoNwzXoAlgQ2vTBmYPA== X-Received: by 2002:a1c:b47:: with SMTP id 68mr13104516wml.148.1543272669127; Mon, 26 Nov 2018 14:51:09 -0800 (PST) Received: from [10.137.2.19] (ip-86-49-251-50.net.upcbroadband.cz. [86.49.251.50]) by smtp.gmail.com with ESMTPSA id p4sm1637738wrs.74.2018.11.26.14.51.07 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Mon, 26 Nov 2018 14:51:08 -0800 (PST) Subject: Re: [HACKERS] PATCH: multivariate histograms and MCV lists To: Thomas Munro Cc: Dean Rasheed , Bruce Momjian , Alvaro Herrera , Andres Freund , Mark Dilger , Adrien Nayrat , Pg Hackers References: <49348328-1a02-7e45-e50f-e1d4d0243c5c@2ndquadrant.com> <4416a567-4452-c5fd-7117-5cc7827b5fad@2ndquadrant.com> <80bc98b2-1c43-1fe8-b316-d447bb68cff2@2ndquadrant.com> <341ca23f-144d-130d-1b45-ddddf581797e@2ndquadrant.com> <8ac8bd94-478d-215d-e6bd-339f1f20a74c@2ndquadrant.com> From: Tomas Vondra Message-ID: Date: Mon, 26 Nov 2018 23:51:06 +0100 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.3.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8 Content-Language: en-US Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 11/26/18 11:29 PM, Thomas Munro wrote: > On Mon, Sep 3, 2018 at 11:17 AM Tomas Vondra > wrote: >> Attached is an updated version of the patch series, adopting a couple of >> improvements - both for MCV lists and histograms. > > Hello Tomas, > > FYI, here are a couple of warnings from GCC (I just noticed because I > turned on -Werror on cfbot so your patch turned red): > > extended_stats.c: In function ‘statext_clauselist_selectivity’: > extended_stats.c:1227:6: error: ‘other_sel’ may be used uninitialized > in this function [-Werror=maybe-uninitialized] > sel = mcv_sel + other_sel; > ^ > extended_stats.c:1091:5: note: ‘other_sel’ was declared here > other_sel, > ^ > extended_stats.c:1227:6: error: ‘mcv_sel’ may be used uninitialized in > this function [-Werror=maybe-uninitialized] > sel = mcv_sel + other_sel; > ^ > extended_stats.c:1087:5: note: ‘mcv_sel’ was declared here > mcv_sel, > ^ > Thanks, I'll fix that in the next version of the patch I'm working on. cheers -- Tomas Vondra http://www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services