Re: [HACKERS] B-tree leaf node structure

2009-10-22 Thread Jeff Davis
On Wed, 2009-10-21 at 23:55 -0700, edwardyf wrote: > If the index is on an attribute with duplicate values. will it be: > 1) one index tuple for each row, though with the same value, or > 2) one index tuple for each value, containing a list of row ids. As Tom already pointed out, #1 is the answer.

Re: [HACKERS] B-tree leaf node structure

2009-10-22 Thread Tom Lane
edwardyf writes: > If the index is on an attribute with duplicate values. will it be: > 1) one index tuple for each row, though with the same value, or > 2) one index tuple for each value, containing a list of row ids. 1. regards, tom lane -- Sent via pgsql-hackers mail