Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-hackers-owner+M243167=pgsql-hackers-arkari@postgresql.org>)
 id 1W8370-0002F2-RK
 for pgsql-hackers@arkaria.postgresql.org; Tue, 28 Jan 2014 07:29:35 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-hackers-owner+M243167=pgsql-hackers-arkari@postgresql.org>)
 id 1W8370-0005GA-83
 for pgsql-hackers@arkaria.postgresql.org; Tue, 28 Jan 2014 07:29:34 +0000
Received: from makus.postgresql.org ([2001:4800:7903:4::125])
 by malur.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <hlinnakangas@vmware.com>) id 1W836y-0005G0-AL
 for pgsql-hackers@postgresql.org; Tue, 28 Jan 2014 07:29:32 +0000
Received: from smtp-outbound-2.vmware.com ([208.91.2.13])
 by makus.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <hlinnakangas@vmware.com>) id 1W836v-0005hP-Ny
 for pgsql-hackers@postgresql.org; Tue, 28 Jan 2014 07:29:31 +0000
Received: from sc9-mailhost2.vmware.com (sc9-mailhost2.vmware.com
 [10.113.161.72])
 by smtp-outbound-2.vmware.com (Postfix) with ESMTP id ABF83280B9;
 Mon, 27 Jan 2014 23:29:28 -0800 (PST)
Received: from zcs-prod-ext-mta-2.vmware.com (zcs-prod-ext-mta-2.vmware.com
 [10.113.62.224])
 by sc9-mailhost2.vmware.com (Postfix) with ESMTP id A6DCFB03FD;
 Mon, 27 Jan 2014 23:29:28 -0800 (PST)
Received: from zcs-prod-ext-mta-2.vmware.com (localhost.localdomain
 [127.0.0.1])
 by zcs-prod-ext-mta-2.vmware.com (Postfix) with ESMTP id 32E85C005E;
 Mon, 27 Jan 2014 23:30:08 -0800 (PST)
Received: from [192.168.1.90] (zimbra-prod-ext-proxy-vip.vmware.com
 [10.113.63.87])
 by zcs-prod-ext-mta-2.vmware.com (Postfix) with ESMTPSA;
 Mon, 27 Jan 2014 23:30:06 -0800 (PST)
Message-ID: <52E75C54.9050209@vmware.com>
Date: Tue, 28 Jan 2014 09:29:24 +0200
From: Heikki Linnakangas <hlinnakangas@vmware.com>
Organization: VMware
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
 rv:17.0) Gecko/20131103 Icedove/17.0.10
MIME-Version: 1.0
To: Tomas Vondra <tv@fuzzy.cz>
CC: pgsql-hackers@postgresql.org
Subject: Re: GIN improvements part2: fast scan
References: 
 <CAPpHfdvftaJq7www381naLw1=4u0h+qpXgWvNhcEB9HMVywbGg@mail.gmail.com>
 <51C4ACC5.2090707@vmware.com>
 <CAPpHfduJ-X9WKR9h-vyTrNEVNR37ZDx05qOLkA3ys3j-14uKXA@mail.gmail.com>
 <CAPpHfduRrMOvXNrmJ0+ALk9dDR3Z34HpNdQPkQZtF_oYX58h9A@mail.gmail.com>
 <51D00FB6.9030008@vmware.com>
 <CAPpHfdtsDe-O6oQdCZUh6N1gGOMz0XKTMNQro-fueg-R06PaWw@mail.gmail.com>
 <528533D9.3040501@vmware.com>
 <CAPpHfduOvUFT+GgCrnBOzRR19eTb9mDsDJwU=S0h477fdgr=RA@mail.gmail.com>
 <CAPpHfdtZOhsmz_uf5BfdXcj5W3zk3K-PYxFc8-7eQw-nPXX1DA@mail.gmail.com>
 <CAPpHfdsEKFmrOU51EWSbF-RDESasSVa2YjoyFoG+0jCZOn1qjw@mail.gmail.com>
 <CAPpHfdvs-EHiwmTgfK=uJ4W3OjskVHyfkuehtyrKfKY_KmMpVw@mail.gmail.com>
 <52E141BA.5000302@vmware.com> <52E4141E.60609@fuzzy.cz>
 <52E42AD0.5060600@vmware.com> <52E4AA3A.9000607@fuzzy.cz>
 <52E53458.2010106@vmware.com>
 <CAPpHfdticvY2+RGTxzQdrr4YSQie+vYGRDRBTuG1ZxBmjwGrOA@mail.gmail.com>
 <CAPpHfduivz3MOA8_o+44n_Z0P-n+WCW=K1DrH+-g3gb-cbM2aA@mail.gmail.com>
 <52E72A10.5040908@fuzzy.cz>
In-Reply-To: <52E72A10.5040908@fuzzy.cz>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
X-Pg-Spam-Score: -7.4 (-------)
List-Archive: <http://archives.postgresql.org/pgsql-hackers>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-hackers.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@postgresql.org>
List-Post: <mailto:pgsql-hackers@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-hackers>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-hackers>
X-Mailing-List: pgsql-hackers
Precedence: bulk
Sender: pgsql-hackers-owner@postgresql.org

On 01/28/2014 05:54 AM, Tomas Vondra wrote:
> Then I ran those scripts on:
>
>    * 9.3
>    * 9.4 with Heikki's patches (9.4-heikki)
>    * 9.4 with Heikki's and first patch (9.4-alex-1)
>    * 9.4 with Heikki's and both patches (9.4-alex-2)

It would be good to also test with unpatched 9.4 (ie. git master). The 
packed posting lists patch might account for a large part of the 
differences between 9.3 and the patched 9.4 versions.

- Heikki


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers