Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1XXV4A-0002MZ-3T for pgsql-hackers@arkaria.postgresql.org; Fri, 26 Sep 2014 12:56:06 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1XXV49-0001To-IC for pgsql-hackers@arkaria.postgresql.org; Fri, 26 Sep 2014 12:56:05 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1XXV46-0001Qa-OO for pgsql-hackers@postgresql.org; Fri, 26 Sep 2014 12:56:02 +0000 Received: from smtp-outbound-1.vmware.com ([208.91.2.12]) by magus.postgresql.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.80) (envelope-from ) id 1XXV3y-0000Cy-30 for pgsql-hackers@postgresql.org; Fri, 26 Sep 2014 12:56:01 +0000 Received: from sc9-mailhost3.vmware.com (sc9-mailhost3.vmware.com [10.113.161.73]) by smtp-outbound-1.vmware.com (Postfix) with ESMTP id 7B8F629B79; Fri, 26 Sep 2014 05:55:49 -0700 (PDT) Received: from EX13-CAS-005.vmware.com (EX13-CAS-005.vmware.com [10.113.191.55]) by sc9-mailhost3.vmware.com (Postfix) with ESMTP id 770FD4122A; Fri, 26 Sep 2014 05:55:49 -0700 (PDT) Received: from EX13-MBX-024.vmware.com (10.113.191.44) by EX13-MBX-009.vmware.com (10.113.191.29) with Microsoft SMTP Server (TLS) id 15.0.775.38; Fri, 26 Sep 2014 05:55:48 -0700 Received: from [192.168.1.90] (10.113.160.246) by EX13-MBX-024.vmware.com (10.113.191.44) with Microsoft SMTP Server (TLS) id 15.0.775.38; Fri, 26 Sep 2014 05:55:48 -0700 Message-ID: <5425623E.3030502@vmware.com> Date: Fri, 26 Sep 2014 15:55:26 +0300 From: Heikki Linnakangas Organization: VMware User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:31.0) Gecko/20100101 Icedove/31.0 MIME-Version: 1.0 To: Thom Brown CC: Tomas Vondra , PostgreSQL-development , Alexander Korotkov Subject: Re: GIN improvements part2: fast scan References: <52E4AA3A.9000607@fuzzy.cz> <52E53458.2010106@vmware.com> <52F36245.6070006@vmware.com> <52F4E094.9040303@vmware.com> <5305CF6E.1080508@vmware.com> <531F8994.3040008@fuzzy.cz> <53208B4D.5000806@vmware.com> In-Reply-To: Content-Type: text/plain; charset="utf-8"; format=flowed Content-Transfer-Encoding: 7bit X-Originating-IP: [10.113.160.246] X-ClientProxiedBy: EX13-CAS-013.vmware.com (10.113.191.65) To EX13-MBX-024.vmware.com (10.113.191.44) X-Pg-Spam-Score: -7.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 On 09/25/2014 09:05 PM, Thom Brown wrote: > On 12 March 2014 16:29, Heikki Linnakangas wrote: >> Good point. We have done two major changes to GIN in this release cycle: >> changed the data page format and made it possible to skip items without >> fetching all the keys ("fast scan"). gincostestimate doesn't know about >> either change. > > Did this cost estimation issue get fixed? Nope. > If not, and if this is due for 9.5, can this be removed from the 9.4 open items list? Removed and moved to the TODO list. It's a pity, but no-one seems to have a great idea on what to do about the cost estimation, nor interest in working on it. - Heikki -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers