B-tree leaf node structure

From: edwardyf <edwardyf(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: B-tree leaf node structure
Date: 2009-10-22 06:55:09
Message-ID: 26004939.post@talk.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


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-tp26004939p26004939.html
Sent from the PostgreSQL - hackers mailing list archive at Nabble.com.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2009-10-22 07:21:42 Re: Hot standby, prepared xacts, locks
Previous Message Pavel Stehule 2009-10-22 06:51:42 some possible parser cleaning: drop support column(table) syntax