DBA / Database

What is the difference between a regular CTE and a recursive CTE?

Tell us about your experience with Oracle and your overall project experience.

Have you worked with Scrum? Tell us about it.

It doesn't mean we are back on track

How to set up a floating IP through Patroni so that the client does not know which node it will connect to?

What is a procedure in PL/SQL?

What is checkpoint_completion_target and what value is recommended?

Tell me about the architecture of Patroni PostgreSQL clusters

What is Mutating table error?

How are WAL segments managed and reused?

How do you monitor database performance and what do you do when CPU usage is high or queries are slow?

Middle+

Иннотех

Реплики без короны — они в режиме read-only или нет?

Have you had experience migrating between PostgreSQL and MS SQL Server?

Have you had experience with subpartitioning?

How did you manage user access rights to the database? How did you create user groups and assign permissions?

Can data be lost if the master crashes and WAL files haven't reached the replicas?

What is MVCC (Multi-Version Concurrency Control)?

What are the transaction isolation levels in SQL Server?

What do you know about Python libraries: pandas, NumPy, PySpark, SQLAlchemy, requests, PyYAML?

How to protect the target table from duplicates when inserting data from a temporary table? How to update existing records with more recent data (upsert)?