Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 785BF650245 for ; Thu, 24 Jul 2008 15:25:20 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 46876-05 for ; Thu, 24 Jul 2008 15:25:15 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from hook.sigaev.ru (hook.sigaev.ru [212.192.243.50]) by postgresql.org (Postfix) with ESMTP id B0D63650217 for ; Thu, 24 Jul 2008 15:25:16 -0300 (ADT) Received: by hook.sigaev.ru (Postfix, from userid 1003) id 292CB398ED; Thu, 24 Jul 2008 22:25:19 +0400 (MSD) Received: from xor.sai.msu.ru (ppp91-76-165-199.pppoe.mtu-net.ru [91.76.165.199]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by hook.sigaev.ru (Postfix) with ESMTP id 637C7398E0; Thu, 24 Jul 2008 22:25:16 +0400 (MSD) Message-ID: <4888C90B.3020704@sigaev.ru> Date: Thu, 24 Jul 2008 22:25:15 +0400 From: Teodor Sigaev User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.8.1.15) Gecko/20080715 SeaMonkey/1.1.10 MIME-Version: 1.0 To: Tom Lane CC: Pgsql Hackers Subject: Re: [PATCHES] GIN improvements References: <483FD205.4090904@sigaev.ru> <486BC501.6060605@sigaev.ru> <27880.1215810535@sss.pgh.pa.us> <487A6E0C.3090600@sigaev.ru> <8993.1216843701@sss.pgh.pa.us> <4888A594.6010102@sigaev.ru> <7913.1216918895@sss.pgh.pa.us> <8177.1216920042@sss.pgh.pa.us> In-Reply-To: <8177.1216920042@sss.pgh.pa.us> Content-Type: text/plain; charset=KOI8-R; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200807/1144 X-Sequence-Number: 121404 > operations such as page splits. Do we need to change the planner to > assume that this only works nicely for btree? It seems to that direction (backward or forward) has meaning only for indexes with amcanorder = true. With amcanorder=false results will be occasionally for any direction. -- Teodor Sigaev E-mail: teodor@sigaev.ru WWW: http://www.sigaev.ru/