Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1XUAcj-0004LY-6v for pgsql-hackers@arkaria.postgresql.org; Wed, 17 Sep 2014 08:30:01 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1XUAci-0008UD-IT for pgsql-hackers@arkaria.postgresql.org; Wed, 17 Sep 2014 08:30:00 +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 1XUAch-0008TK-12 for pgsql-hackers@postgresql.org; Wed, 17 Sep 2014 08:29:59 +0000 Received: from mail-lb0-x22e.google.com ([2a00:1450:4010:c04::22e]) by magus.postgresql.org with esmtps (TLS1.0:RSA_AES_256_CBC_SHA1:256) (Exim 4.80) (envelope-from ) id 1XUAca-00017F-4w for pgsql-hackers@postgresql.org; Wed, 17 Sep 2014 08:29:57 +0000 Received: by mail-lb0-f174.google.com with SMTP id 10so1329948lbg.5 for ; Wed, 17 Sep 2014 01:29:50 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=hasegeli.com; s=google; h=date:from:to:cc:subject:message-id:references:mime-version :content-type:content-disposition:in-reply-to:user-agent; bh=hMDyiPLE1rPlREO7OBlXQqHT+dATPGf8lMDKMGkvyUk=; b=dJvw8KF23Thi0/FGjgoQmaBU0vsmxfgZ6VQxViMEtgh5CHcvWU1VVp1CIQwK8om3xJ 0ycuTzCAABxSLdINRikuFUpCpNRa+qqOXKyB1LaRT/B1uWeKUcV44YeQqPvVALg/2pqB LCPYlBZy0kF+ZBVT2kHgmMqKFOOzpyVKzherI= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-type:content-disposition:in-reply-to :user-agent; bh=hMDyiPLE1rPlREO7OBlXQqHT+dATPGf8lMDKMGkvyUk=; b=doxHxhzwUf8Eep1fr1udim8mqePrb4sW9hmtyQ3xx4s+FgOc7z7Bt/nS7CIwkuI12q E38hGKYPQmK6v1pS9jSiXBVWQgNN/8v4CwK+lPiDTYuON1VkOyZPRbtfSCsgwPcqq+2/ zkN9wnEEu1zRiNhe4eX8RGJgcNAbN10ZE4KzrWHJDHLwOEa++6N/f9kVklv84+TB4Ivo iS1g6kudI1sly23Web6+N59UaR19V0E5EMvbRjFCMjIZ5R6FuBtMnqbG2oHFqy47PNcq QoH+EL50RyPZ6JLsdMxWo6uXhqAhpci5Yow2V3bRbgniCT5wgCC+GHsGnJNg86XI2BDO XDmg== X-Gm-Message-State: ALoCoQkaaxgGcIEaHsBiGOnuWBzCbFmLECHYfVb9ew8gilulSN9vGxuNbTeE2xWG9r8pGeePIdBX X-Received: by 10.152.7.8 with SMTP id f8mr42080829laa.27.1410942590314; Wed, 17 Sep 2014 01:29:50 -0700 (PDT) Received: from hasegeli.com ([24.133.146.176]) by mx.google.com with ESMTPSA id v13sm5704611laz.10.2014.09.17.01.29.48 for (version=TLSv1.2 cipher=RC4-SHA bits=128/128); Wed, 17 Sep 2014 01:29:49 -0700 (PDT) Date: Wed, 17 Sep 2014 11:30:00 +0300 From: Emre Hasegeli To: Alexander Korotkov Cc: PostgreSQL Hackers , Heikki Linnakangas Subject: Re: KNN-GiST with recheck Message-ID: <20140917083000.GA7869@hasegeli.com> References: <20140803134809.GA58181@hasegeli-2.local> <20140914180936.GA5084@hasegeli.com> <20140917081250.GA28651@hasegeli.com> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline In-Reply-To: <20140917081250.GA28651@hasegeli.com> User-Agent: Mutt/1.5.21 (2010-09-15) X-Pg-Spam-Score: -2.0 (--) 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 > I managed to break it again by ordering rows only by the second column > of the index. Test script attached. I was confused. It is undefined behavior. Sorry for the noise. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers