Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fXDXN-00041R-LI for pgsql-hackers@arkaria.postgresql.org; Sun, 24 Jun 2018 22:31:14 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fXDXL-0006rL-GN for pgsql-hackers@arkaria.postgresql.org; Sun, 24 Jun 2018 22:31:11 +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.89) (envelope-from ) id 1fXDXL-0006rE-1r for pgsql-hackers@lists.postgresql.org; Sun, 24 Jun 2018 22:31:11 +0000 Received: from mail-wr0-x243.google.com ([2a00:1450:400c:c0c::243]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1fXDXH-000534-K1 for pgsql-hackers@postgresql.org; Sun, 24 Jun 2018 22:31:09 +0000 Received: by mail-wr0-x243.google.com with SMTP id w10-v6so11681682wrk.9 for ; Sun, 24 Jun 2018 15:31:07 -0700 (PDT) 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=14dFzlOKqZBg9ZbyqZ+puzTkA8Y7g9y1qQw24pw0FeQ=; b=nj9fvobeqqVfF6NAHWCwUQHWvuO86ubMoF655cybYWfD+NGLWygrCHUmlDwuN81Kd2 0BTWmx2XlQfEpM6YK97pdNzQIhMAtXKQx4ykShLFVoTS0MYbrhZ27aQiU1GuRA6pLEfM AltdGdvTD3Gl0cSW7aARrINlESekBpWCOpATBrtPFqAosqXbb1gKQDqzzUWpZJPrHnWv 3zKAp4ThWmQCPEVKLzIb7ebfquN/ynun3yEGwpTvkSpNqWFaX4IE+blEn63qzDcYfF0A CEgMB/Cs7E2M7c8Pd03Bqw/0sV2oONmN9mfCpREMNxa50EjDXRIQy9OvkAnwtB6ZtwC2 oYFA== 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=14dFzlOKqZBg9ZbyqZ+puzTkA8Y7g9y1qQw24pw0FeQ=; b=syxjeV2a/h9pzm7ZJgHTp7ZLWyqbA+nryiC2AK1qhyELxZl/ftnKCvXiH64wp42RDq 1uIJXRXTETId7lVb/1iYPF8TPEY+q38ILqCn58NWfEB7ucS5PhzeS2Fqh09eN+i9Za1Z Skjkz3KXot6lw0aOIU8SScd5BIcpKma3IWHrcRdFvHVPbQiwQhnYErXX76jYywTJxKir A15ELL8SwhYf5hwrKpsq+UO9jt4feK9pba4MTFGNMJAx9M5VCmIr/FABtBJHsHRqpZwi vDrBOM0jTMvqWSJQkzp1/09s8U8A6zHm9sqEn3isVS8mtlkyTs7ZeeC1FDYpKRdcM1Jy sJ+w== X-Gm-Message-State: APt69E1cR0KlupDihFHpArb54yuw1aQMw4ttFBI9ta/YRbaStLAtW+m7 ZEn7/988ZZL5Y1x1gF0XFkObP1CsTt80No6MVQW9C/oIEFwBES9j0jwRxTERdcL9wCc5G9KjhA6 LNZV9i5cBc2rYDKKUb7AtK1akqXbZNyLvRV2XQCEX14XY0QliRjlL3xp8kkom45qC0nM4rx0eiR nVsyuMs0H+ X-Google-Smtp-Source: AAOMgpcauGYOffFhp/2n6na0YozNuShuIK1iPGr/GBDNnrIYz6edXamsRw/iSo0IriIWW1BFPB1HNA== X-Received: by 2002:adf:84c5:: with SMTP id 63-v6mr2273815wrg.50.1529879465437; Sun, 24 Jun 2018 15:31:05 -0700 (PDT) Received: from [10.137.2.19] (ip-78-102-97-226.net.upcbroadband.cz. [78.102.97.226]) by smtp.gmail.com with ESMTPSA id e74-v6sm9365737wma.44.2018.06.24.15.31.04 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Sun, 24 Jun 2018 15:31:04 -0700 (PDT) Subject: Re: WIP: BRIN multi-range indexes To: Thomas Munro Cc: Tom Lane , Andres Freund , Mark Dilger , Alvaro Herrera , Pg Hackers References: <20180123200537.gfx5hxcp5k5hktpe@alvherre.pgsql> <821c4c1d-592e-8916-e323-04607b11777e@2ndquadrant.com> <104E8BB8-35FF-4AA8-9871-6AFF04E4CAF3@gmail.com> <0afde2fc-e160-004f-8fe2-c65302ac3760@2ndquadrant.com> <22674.1517874015@sss.pgh.pa.us> <3e924a4c-6ca0-cc10-aebb-5004fc002800@2ndquadrant.com> <20180302035538.gkqgtcv6kmn2cklw@alap3.anarazel.de> <18526.1519963686@sss.pgh.pa.us> <1c1c1ced-1f79-a0ee-e5cd-858ca3eb9d74@2ndquadrant.com> <9b7551f2-93fb-3708-2705-35c42f0e6734@2ndquadrant.com> <4b0f4205-57b2-77d4-d500-510cbad25d7b@2ndquadrant.com> <459eef3e-48c7-0f5a-8356-992442a78bb6@2ndquadrant.com> From: Tomas Vondra Message-ID: <6fd42b0c-b818-5889-c73e-bb2edcdde960@2ndquadrant.com> Date: Mon, 25 Jun 2018 00:31:00 +0200 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Thunderbird/52.5.2 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8 Content-Language: en-US Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 06/24/2018 11:39 PM, Thomas Munro wrote: > On Sun, Jun 24, 2018 at 2:01 PM, Tomas Vondra > wrote: >> Attached is rebased version of this BRIN patch series, fixing mostly the >> breakage due to 372728b0 (aka initial-catalog-data format changes). As >> 2018-07 CF is meant for almost-ready patches, this is more a 2018-09 >> material. But perhaps someone would like to take a look - and I'd have >> to fix it anyway ... > > Hi Tomas, > > FYI Windows doesn't like this: > > src/backend/access/brin/brin_bloom.c(146): warning C4013: 'round' > undefined; assuming extern returning int > [C:\projects\postgresql\postgres.vcxproj] > > brin_bloom.obj : error LNK2019: unresolved external symbol round > referenced in function bloom_init > [C:\projects\postgresql\postgres.vcxproj] > Thanks, I've noticed the failure before, but was not sure what's the exact cause. It seems there's still no 'round' on Windows, so I'll probably fix that by using rint() instead, or something like that. regards -- Tomas Vondra http://www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services