Golang

Tell about Kafka: topics, partitions, consumer groups, delivery guarantees.

Have you worked with ClickHouse? Share your experience.

Tell about Mutex and RWMutex, how do they differ and where do you prefer to use them?

Tell about the influence of GOGC on Garbage Collector operation and how to optimize memory usage.

Questions for interviewers about the company's processes.

Design a system for receiving, decrypting fingerprints, and aggregating data with a load of up to 3 million RPS.

What amount are you expecting?

Why are you looking for a new job?

How to ensure no duplicates when switching between machines (one degrades, the other takes over)?

What happens if a system call (syscall) is blocked?

Have you used EXPLAIN for query optimization? What did you learn and how much did you manage to speed up the queries?

What indexes did you use, on which fields did you choose and why?.

What was the system load and how many parameters were in each request?

How was the service's fault tolerance ensured?

What databases have you worked with?

Tell me about WaitGroup in Go.

Tell us about your experience with PostgreSQL. Have you dealt with optimization issues?

Have you worked with tables for analysts in ClickHouse? What engines have you encountered?

Are there any questions about the interview stages?

Tell about the Go scheduler, how it works, and what algorithm it uses.