Contents

DROP INDEX IF EXISTS message_store.messages_category;

CREATE INDEX messages_category ON message_store.messages (
  message_store.category(stream_name),
  global_position,
  message_store.category(metadata->>'correlationStreamName')
);

Version data entries

16 entries across 16 versions & 1 rubygems

Version	Path
message-db-3.0.0	database/indexes/messages-category.sql
message-db-2.1.6	database/indexes/messages-category.sql
message-db-2.1.5	database/indexes/messages-category.sql
message-db-2.1.4	database/indexes/messages-category.sql
message-db-2.1.3	database/indexes/messages-category.sql
message-db-2.1.2	database/indexes/messages-category.sql
message-db-2.1.1	database/indexes/messages-category.sql
message-db-2.1.0	database/indexes/messages-category.sql
message-db-2.0.2	database/indexes/messages-category.sql
message-db-2.0.1	database/indexes/messages-category.sql
message-db-2.0.0	database/indexes/messages-category.sql
message-db-1.1.3	database/indexes/messages-category.sql
message-db-1.1.2	database/indexes/messages-category.sql
message-db-1.1.1	database/indexes/messages-category.sql
message-db-1.1.0	database/indexes/messages-category.sql
message-db-1.0.0	database/indexes/messages-category.sql