Search
Shalom Shmila
May 272 min
TimescaleDB deep dive: unveiling the mysteries of Hypertable partitions | Part 1
Delve into TimescaleDB's hypertables and how automatic partition creation optimizes time-series data management.
Alon Spiegel
Nov 26, 20231 min
Dispelling the Myth: count(*) vs. count(1) Efficiency in Modern Databases
As an experienced DBA, I often encounter the belief that SELECT COUNT(1) is faster than SELECT COUNT(*). While this may have held true...
Alon Spiegel
Jan 7, 20212 min
Real world use case for JSON in RDBMS PostgreSQL
How I used JSON in RDBMS. I used PostgreSQL but other databases that support JSON, such as MySQL, can also be used