Indexing

GiST and SP-GiST indexes can be created for table columns of temporal poses and temporal pose chains, and of pose sets and pose chain sets. An example of index creation is follows:

CREATE INDEX Trips_Trip_SPGist_Idx ON Trips USING SPGist(Trip);

The GiST and SP-GiST indexes store the bounding box of the values, which is an stbox, as for all spatiotemporal types; the box of a pose chain covers the composed position of every one of its joints. A set is indexed by the box it stores, as described in the section called “Indexing”.

A GiST or SP-GiST index can accelerate queries involving the following operators:

These operators work on bounding boxes, not the entire values.