Contents

CREATE UNIQUE INDEX idx_streams_context_and_stream_name_and_stream_id ON public.streams USING btree (context, stream_name, stream_id);
-- This index is used when searching by the specific stream and event's types
CREATE INDEX idx_events_stream_id_and_revision_and_type ON public.events USING btree (stream_id, stream_revision, type);

-- This index is used when searching by "all" stream using stream's attributes(context, stream_name, stream_id) and
-- event's types. PG's query planner picks this index when none of the given event's type exist
CREATE INDEX idx_events_type_and_stream_id_and_position ON public.events USING btree (type, stream_id, global_position);

-- This index is used when searching by "all" stream using stream's attributes(context, stream_name, stream_id) and
-- event's types. PG's query planner picks this index when some of the given event's types exist
CREATE INDEX idx_events_position_and_type ON public.events USING btree (global_position, type);

CREATE INDEX idx_events_link_id ON public.events USING btree (link_id);

Version data entries

14 entries across 14 versions & 1 rubygems

Version	Path
pg_eventstore-0.6.0	db/initial/indexes.sql
pg_eventstore-0.5.3	db/initial/indexes.sql
pg_eventstore-0.5.2	db/initial/indexes.sql
pg_eventstore-0.5.0	db/initial/indexes.sql
pg_eventstore-0.4.0	db/initial/indexes.sql
pg_eventstore-0.3.0	db/initial/indexes.sql
pg_eventstore-0.2.6	db/initial/indexes.sql
pg_eventstore-0.2.5	db/initial/indexes.sql
pg_eventstore-0.2.4	db/initial/indexes.sql
pg_eventstore-0.2.3	db/initial/indexes.sql
pg_eventstore-0.2.2	db/initial/indexes.sql
pg_eventstore-0.2.1	db/initial/indexes.sql
pg_eventstore-0.2.0	db/initial/indexes.sql
pg_eventstore-0.1.0	db/indexes.sql