Re: Doubt in IndexScanDescData
От | Hans-Juergen Schoenig |
---|---|
Тема | Re: Doubt in IndexScanDescData |
Дата | |
Msg-id | ECF95463-D987-4864-8B38-BD1E2C6C52D0@cybertec.at обсуждение исходный текст |
Ответ на | Doubt in IndexScanDescData (Suresh <suiyengar@yahoo.com>) |
Ответы |
Re: Doubt in IndexScanDescData
segfault in locking code |
Список | pgsql-hackers |
On Feb 17, 2008, at 4:33 PM, Suresh wrote:
[ "include/access/relscan.h" ]
In IndexScanDescData, whats the purpose of having two Relation variables.
typedef struct IndexScanDescData
{
Relation heapRelation; /* heap relation descriptor, or NULL */
Relation indexRelation; /* index relation descriptor */
....
...
}IndexScanDescData;
The index does not contain the entire tuple. If you index column A the index will not contain values in column B of the same table.
Thus, if you find a record in the index one of the things which have to be done is to get the record from disk to check visibility and other columns.
best regards,
hans-juergen schoenig
--
Cybertec Schönig & Schönig GmbH
PostgreSQL Solutions and Support
Gröhrmühlgasse 26, 2700 Wiener Neustadt
Tel: +43/1/205 10 35 / 340
www.postgresql.at, www.cybertec.at
В списке pgsql-hackers по дате отправления: