A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...

面向数据库架构师、DBA 和应用开发者。本文从 PostgreSQL 与 DuckDB 的源码出发，解释 index scan 的本质、执行链路、代价模型、适用边界和常见误区。 上一篇 seq scan 讲的是“把表从头到尾读一遍”的基线能力。index scan 则是另一类基本功：先通过索引定位候选行，再 ...

Another year passes. I was hoping to write more articles instead of just these end-of-the-year screeds, but I almost died in the spring semester, and it sucked up my time. Nevertheless, I will go ...

Asynchronous I/O, OAuth authentication, expanded SQL standards support, and new extension capabilities give developers faster performance, stronger security, and greater flexibility. The PostgreSQL ...

Community driven content discussing all aspects of software development from DevOps to design patterns. The AWS Certified Solutions Architect Associate certification exam, exam code SAA-C03, validates ...