PostgreSQL question# Database - 数据库
c*t
1 楼
I have several tables with identical schema:
tupleId int unique,
data bytea
I am writing some server procedures that trys to lookup
a tuple using (tableOid, tupleId) pair. The reason to
break down the tables are to make indexing easier (data
is indexed using custom functions).
What's the efficient way of getting Datnum that represents
the tuple? Most of the time I have 1 tuple to retrieve,
but there also times that I have a bunch.
I could get the Relation using RelationIdGetRelation (
tupleId int unique,
data bytea
I am writing some server procedures that trys to lookup
a tuple using (tableOid, tupleId) pair. The reason to
break down the tables are to make indexing easier (data
is indexed using custom functions).
What's the efficient way of getting Datnum that represents
the tuple? Most of the time I have 1 tuple to retrieve,
but there also times that I have a bunch.
I could get the Relation using RelationIdGetRelation (