Postgres Pro
Downloads
Home   >   mailing lists

[HACKERS] Regarding B-Tree Lookup - Mailing list pgsql-hackers

From Mahi Gurram
Subject [HACKERS] Regarding B-Tree Lookup
Date
Msg-id CAGg=GudoYG8fjLbxcQiQcTtMggvta8RuOUvrmn53NSvH0KEk8A@mail.gmail.com
Whole thread Raw
Responses Re: [HACKERS] Regarding B-Tree Lookup  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-hackers
Tree view
Hi,

I'm building some custom extension on top of postgres 9.6.1. As part of that, I would like to read Heap Tuple directly from my extension using Primary Key.

By default, postgres table index(B-Tree) its PrimaryKey(PK). So, i would like to get TID by doing a lookup into PK's B-Tree index. Using which i could read HeapTuple directly.

Please suggest me the easiest way to lookup into PK's B-Tree index for getting TIDs.

Suggesting a postgres extensions which does B-Tree lookup will also helps me.

Awaiting your response.

Thanks & Best Regards
- Mahi

pgsql-hackers by date:

Previous
From: Dmitriy Sarafannikov
Date:
Subject: Re: [HACKERS] [PROPOSAL] Use SnapshotAny in get_actual_variable_range
Next
From: Magnus Hagander
Date:
Subject: Re: [HACKERS] [PostgreSQL 10] default of hot_standby should be "on"?