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

Contributors

  • Ashutosh Bapat (आशुतोष बापट)
  • Ashutosh Bapat
Powered by Blogger.