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.
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
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.
thanx
--
View this message in context:
http://www.nabble.com/B-tree-leaf-node-structure-tp26004939p
