...

Indexes above are designed to optimize following queries:

1. By dataspace, schema set, anchor. Order by timestamp desc.
2. By dataspace, anchor. Order by timestamp desc.
3. By dataspace, schema set, payload content. Order by timestamp desc.

...

1. Adding a payload content condition to the 3 kinds of queries above. In this case, the gin index is used in combination with the index having the corresponding fields. See attached explain plan for an example.

References

• CPS-191: Core and Temporal Integration Design
• https://www.timescale.com/

...