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

• 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.
• Referenced generic plan.
• Resilient collapse limit. This feature attempts to eliminate the effect of subplan pullups and other optimisations that cause join tree growth and, as a result, exceed the join collapse limit => bad query plans.

• 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.
• pg_pathcheck. An extension that enables users of Postgres or PG fork to check (since PG19) potential vulnerabilities of the planner code.
• 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.

• Batch insert in logical replication. An attempt to employ the COPY multi-insert approach to quickly replicate massive batches of tuples. specs, Design.

For encrypted communication or to verify my signatures:

Fingerprint: E19F A740 5577 F766 F980 2F99 8044 24B7 0870 EC53
Download: pgp.asc