Silvan 43404d960c fix(eventstore): order by sequence if filter by aggregate id (#8019) ...

# Which Problems Are Solved

Queriying events by an aggregate id can produce high loads on the
database if the aggregate id contains many events (count > 1000000).

# How the Problems Are Solved

Instead of using the postion and in_tx_order columns we use the sequence
column which guarantees correct ordering in a single aggregate and uses
more optimised indexes.

# Additional Context

Closes https://github.com/zitadel/DevOps/issues/50

Co-authored-by: Livio Spring <livio.a@gmail.com>

2024-05-28 08:50:42 +02:00

..

handler

chore: fix function names in comment (#7723)

2024-04-08 08:15:44 +00:00

repository

fix(eventstore): order by sequence if filter by aggregate id (#8019)

2024-05-28 08:50:42 +02:00

v1/models

refactor: rename package errors to zerrors (#7039)

2023-12-08 15:30:55 +01:00

v3

fix(crdb): obtain latest sequences when the tx is retried (#7795)

2024-04-18 15:39:40 +02:00

aggregate.go

feat: restrict languages (#6931)

2023-12-05 11:12:01 +00:00

asset.go

fix(eventstore): sub queries (#1805)

2021-07-06 13:55:57 +02:00

bench_payload.txt

feat(eventstore): increase parallel write capabilities (#5940)

2023-10-19 12:19:10 +02:00

config.go

fix(eventstore): retry push on primary key sequence collision (#7420)

2024-02-23 08:29:10 +00:00

event_base.go

feat(eventstore): increase parallel write capabilities (#5940)

2023-10-19 12:19:10 +02:00

event.go

refactor: rename package errors to zerrors (#7039)

2023-12-08 15:30:55 +01:00

eventstore_bench_test.go

feat(eventstore): increase parallel write capabilities (#5940)

2023-10-19 12:19:10 +02:00

eventstore_pusher_test.go

fix(crdb): obtain latest sequences when the tx is retried (#7795)

2024-04-18 15:39:40 +02:00

eventstore_querier_test.go

feat(eventstore): increase parallel write capabilities (#5940)

2023-10-19 12:19:10 +02:00

eventstore_test.go

chore: use pgx v5 (#7577)

2024-03-27 15:48:22 +02:00

eventstore.go

chore: use pgx v5 (#7577)

2024-03-27 15:48:22 +02:00

example_test.go

fix(setup): init projections (#7194)

2024-01-25 17:28:20 +01:00

local_crdb_test.go

chore(core): update dependencies (#7517)

2024-03-11 10:43:56 +00:00

read_model.go

feat(api): feature flags (#7356)

2024-02-28 10:55:54 +02:00

search_query_test.go

fix(eventstore): improve pagination of handler filter (#6968)

2023-12-01 12:25:41 +00:00

search_query.go

fix(setup): init projections (#7194)

2024-01-25 17:28:20 +01:00

subscription.go

feat(eventstore): increase parallel write capabilities (#5940)

2023-10-19 12:19:10 +02:00

unique_constraint.go

feat(eventstore): increase parallel write capabilities (#5940)

2023-10-19 12:19:10 +02:00

version_test.go

feat(eventstore): increase parallel write capabilities (#5940)

2023-10-19 12:19:10 +02:00

version.go

refactor: rename package errors to zerrors (#7039)

2023-12-08 15:30:55 +01:00

write_model.go

feat(eventstore): increase parallel write capabilities (#5940)

2023-10-19 12:19:10 +02:00