You thought it was a composite index, but doesn't the optimizer rearrange the columns in the correct order?
Golang
Can you tell me about deploying via Docker — how did it work?
Why didn't you choose Testcontainers?
Your service was an API used by other services. In Redis, you stored data for enrichment — why didn't you call the directory service (about warehouses, etc.) on each request?
And where did you store the metrics? Did you not use VictoriaMetrics?
Okay, then what exactly has changed in the request itself?
You mentioned that you used Redis for working with Kafka — can you explain why?
What sorting method is used in the solution?
Did you rewrite the index or the query — what exactly changed in the query?
You mentioned there were issues with indexes — can you tell specifically?
How were the metrics configured? Did the service push metrics or pull them?
LRU stores data at the application level — in what sense does cache behavior become unpredictable when scaling?
Have you used Testify?
There is a library in Go — LRU, where you can pass Any and set TTL. Why was Redis chosen instead of it?
What is the algorithm complexity and where is the tree here?
Tracing has already been done — what exactly did you do?
What happened when you rolled back the index, rewrote the query, and then applied the same index again?
The service read data from Kafka, enriched it with data from Redis — and then what did it do?
How were your metrics configured? Where do you generally deploy?
And what was done for central logging?