Hi, I'm Andrey 👋

I'm a PostgreSQL Internals Engineer based in Madrid, passionate about data management technologies — query planning and executing, distributed transactions and scalability.

Recent Projects

Core features

• Enforce sorted scan. The core feature suggests that when an SQL query includes an ORDER BY clause for a relation and a LIMIT clause, it is beneficial to have a sorted scan path among the possible scan operators during query optimisation. For instance, this could involve pushing the sort operation to the outer side of an OUTER JOIN. Branches: master, PG 18, alternative-master, alternative PG 18; notes, discussion.
• Selectivity models. The core feature enables users to choose how to combine selectivity estimations on independent clauses. Essential feature in case when the query contains multi-filter or multi-join clause restrictions.

Extensions

• pg_track_optimizer. An extension which is designed to reveal how effectively the database instance executes queries. Provides multiple dimensionless metrics wrapped into a statistics custom type to expose fluctuations of each parameter.
• safesession. An extension that allows connection poolers and automation tools to change a connection to read-only mode, preventing any reversal through role changes or escalation of privileges. Inspired by the popularity of MCP servers and the necessity to give an AI agent database access.
• lolor. Contributor, not an original author. Dedicated to flexible management of large objects - moving out of the system catalogue, logically replicated, etc.