Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Vg7Ni-0002Jb-6k for pgsql-hackers@arkaria.postgresql.org; Tue, 12 Nov 2013 06:23:22 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Vg7Nh-0003jx-HJ for pgsql-hackers@arkaria.postgresql.org; Tue, 12 Nov 2013 06:23:21 +0000 Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Vg7Ng-0003jp-IJ for pgsql-hackers@postgresql.org; Tue, 12 Nov 2013 06:23:20 +0000 Received: from outmail149075.authsmtp.net ([62.13.149.75]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Vg7Ne-0005wS-Fq for pgsql-hackers@postgresql.org; Tue, 12 Nov 2013 06:23:20 +0000 Received: from mail-c235.authsmtp.com (mail-c235.authsmtp.com [62.13.128.235]) by punt14.authsmtp.com (8.14.2/8.14.2) with ESMTP id rAC6NFf1088178; Tue, 12 Nov 2013 06:23:15 GMT Received: from ayaki.localdomain (58-7-62-40.dyn.iinet.net.au [58.7.62.40]) (authenticated bits=0) by mail.authsmtp.com (8.14.2/8.14.2/) with ESMTP id rAC6N9jR073880 (version=TLSv1/SSLv3 cipher=DHE-RSA-CAMELLIA256-SHA bits=256 verify=NO); Tue, 12 Nov 2013 06:23:12 GMT Message-ID: <5281C94C.30308@2ndquadrant.com> Date: Tue, 12 Nov 2013 14:23:08 +0800 From: Craig Ringer Organization: 2nd Quadrant User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:24.0) Gecko/20100101 Thunderbird/24.0 MIME-Version: 1.0 To: Rohit Goyal , Heikki Linnakangas CC: pgsql-hackers@postgresql.org Subject: Re: Fwd: Test of Algorithm || Indexing Scheme References: <5280C014.7010307@vmware.com> <5281075B.6080302@vmware.com> In-Reply-To: X-Enigmail-Version: 1.6 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Server-Quench: e9133692-4b62-11e3-b802-002590a15da7 X-AuthReport-Spam: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-AuthRoute: OCdxZQATClZeVg0b BQteCiNZVAwpPBRK HVkIKg5MJUcNSQVJ NksadRtFaQdbY1ZH HGQLWldEUFt7W2B/ ag4faA1DZVRIXRtu UFdLR1BXCwQmQ21y AGAXCHtycAZOcH4+ YkNmXj4OVUV5dkB0 QFNQR2sEeGZhPWMC AkhYdR5UcAFPdx8U a1UrBXRDAzANdhEY NiQQEgoKCH1xNygH Cj0ANk5aRkhDNzoz QAoDATUqVVkRDwQ1 IxE2K1gTVH0aMkg3 PDMA X-Authentic-SMTP: 61633235383639.1023:706 X-AuthFastPath: 0 (Was 255) X-AuthSMTP-Origin: 58.7.62.40/2525 X-AuthVirus-Status: No virus detected - but ensure you scan with your own anti-virus system. X-Pg-Spam-Score: -2.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 11/12/2013 03:26 AM, Rohit Goyal wrote: > Hi, > > Actually, > > I want to test an algorithm in which I will use store tuple_id in some > other data structure and value of the key of index will contain some > random created by me. Could you please tel me which file need to be > change for it. > > you said something about usage of GiST opclass. Can you please elaborate > ur opinion in detail. It would be of a great help to me. I think you really need to take a few steps back and explain *why* you feel you want to modify the b-tree values. Are you attempting to implement a covering index or index-organized table? "some random created by me" tells us around about nothing about what you're trying to do. -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers