Sadeq Dousti articles - 10 total
PostgreSQL + Outbox Pattern Revamped — Part 2
Part 1 of this series introduced the outbox pattern as a reliable approach for message delivery in...
Connecting from EKS pods to MSK: Setting up IAM, service accounts, trust relationships, and security groups
Recently, we have been working on a project that requires connecting from a pod running in Elastic...
PostgreSQL + Outbox Pattern Revamped — Part 1
This is a two-part series; for part 2, see here. The outbox pattern is a well-known design pattern...
Investigating PostgreSQL's `ANALYZE` Runtime Behavior: Sampling, Table Size, and Cache Effects
PostgreSQL's ANALYZE command is designed to collect statistics for the query planner by sampling a...
The effect of frequent values on histogram_bounds in PostgreSQL
In a recent blog post, I explored statistics in PostgreSQL, with a focus on how the database engine...
PostgreSQL partitioning with desired index names
Introduction A while back, Hetti wrote an article titled Indexing Partitioned Table...
Database: Indexing issues with random UUIDs
UUIDs are very popular among developers as the datatype for the identifier of a table. Database...
Postgres partitioning performance: Hash vs. List
In our design, we came up with a would-be large PostgreSQL table that just stores IDs of incoming...
Ask not what PostgreSQL can do for AI, ask what AI can do for PostgreSQL
Today at PostgreSQL Conference Europe 2023, some key people addressed the future of...
How Gradle disagreed with our Maven project
Preamble I'm a maintainer of a popular open-source project called Logbook. It is "an...