How to identify and analyze a long-running query in PostgreSQL?
Golang
Name four protocols: HTTP, gRPC, WebDAV, ACSA — which one is extra?
How is interaction via a buffered channel implemented and how is data transferred?
Can you list the main types of abstractions used in Kafka?
What is the principle of immutability of string data in programming?
How to determine the maximum number of buffers that can be used in the system?
How to make the execution of two worker() functions parallel instead of sequential (6 seconds → 3 seconds)?
Questions to the interviewer about the company and processes.
What methods can be used to determine when to create an index in a database?
Can you explain how channels work in the system?
What approaches are used for storing text data in the PostgreSQL database?
Why are you considering a new job now?
What is a map in Go? How is it structured (new implementation in Go 1.24)?
How is the handling of panic states and error processing caused by emergencies implemented in Go?
Why did you decide to consider changing jobs?
Have you created wrappers for third-party libraries or tools to simplify their use?
What methods or tools do you use to detect and diagnose errors in code or systems?
When was the last time you used a buffer for storing or exchanging data?
What consequences can arise if the channel remains open and is not closed in the program?
How does the mechanism of writing to a restricted access channel work and what happens during this process?