Walking with the Elephants
My encounter with open source databases.
Friday, July 11, 2025
Efficiency of a sparse hash table
›
When implementing an optimization for derived clause lookup myself, Amit Langote and David Rowley argued about the initial size of hash tabl...
Friday, June 6, 2025
Avoiding disk spills due to PostgreSQL's logical replication
›
Logical replication is a versatile feature offered in PostgreSQL. I have discussed the the theoretical background of this feature in detail ...
Friday, November 29, 2024
The PostgreSQL operator labyrinth
›
While working on SQL/PGQ patch I wanted to find an equality operator for given left and right argument types to construct a condition to ma...
Friday, June 7, 2024
SQL/PGQ and graph theory
›
The story goes almost two decades back. I was studying computer engineering in College of Engineering Pune. Prof Vinayak Joshi had recently...
Friday, May 3, 2024
Property graphs: elements, labels and properties
›
A property graph consists of three types of "things" in it: elements, labels and properties. Elements are nodes or edges in the g...
Wednesday, April 24, 2024
PostgreSQL's memory allocations
›
There's a thread on hackers about recovering memory consumed by paths. A reference count is maintained in each path. Once paths are cre...
Tuesday, April 23, 2024
DBaaG with SQL/PGQ
›
For those who have studied ERD-lore, it's not new that a relational database is very much like a graph. But it has taken SQL, more than ...
›
Home
View web version