Python

How to deal with table bloat in PostgreSQL?

Why can GIN indexes grow?

What is the difference between threading and asyncio?

How is an instance of a class initialized in Python and what is the purpose of __new__?

Tell us what you do at your current company and what tasks are within your area of responsibility.

How to synchronize or securely transfer data between multiple threads or coroutines?

Provide an example of the interface segregation principle in the Python standard library.

Have you used multiple inheritance?

Approximately how much time passed between the appearance of the bug and its fix?

Given an integer array height of length n, with n vertical lines at points (i, 0) and (i, height[i]), find two lines that, together with the x-axis, form a container that holds the maximum amount of water. Return the maximum volume of water such a container can hold. Note that the container cannot be tilted.

Why are access level agreements private, protected, and public necessary in Python?

What are stable and unstable components?

When and why do you choose threading?

What data structure would you use if you need to efficiently add and remove elements from the beginning and end?

What do you prefer: asynchrony or multithreading? What's the difference?

What to do if an SQL query is already optimized but still remains heavy?

What are the differences between TCP and UDP, and at what level do they operate?

Have you used RabbitMQ in production?

Write a decorator rate_limit(max_calls, period) that limits the number of function calls with a sliding window over time: no more than max_calls calls in the last period seconds. If the limit is exceeded, the call should not be executed. Consider that the function can be called from multiple threads. Example: @rate_limit(max_calls=5, period=60) the sixth call within a minute should be rejected.

Do you use type annotations in your work?