Mastodawn

Tomorrow marks day one of an exciting new chapter! 🚀 I’m thrilled to announce I’m joining Tiger Data (formerly Timescale) as a Database Support Engineer.

I'll be taking my passion for #PostgreSQL optimization into the world of time-series data, helping teams architect high-performance, AI-ready data systems. Time to build! 🐅🐘

#TimescaleDB #DatabaseEngineering #AI #AWSCommunityBuilder

Giovanni Martinez Apr 28

Compared DocumentDB vs Aurora PostgreSQL for JSON workloads — here's what surprised me.
The real differences? Query flexibility, indexing behavior, and nested JSON at scale. Not what I expected going in.
If you're choosing between these two, this might save you some time.
What's been your experience? Let me know!
https://dub.sh/3LkmkrF
#AWS #PostgreSQL #DocumentDB #JSON #CloudArchitecture #DatabaseEngineering

Giovanni Martinez Apr 23

I always wanted quick, no-fuss Postgres tools for everyday use, so I finally built them.

I now use my own toolkit daily to: ⚡️ Build connection strings ⚡️ Format complex queries ⚡️ Analyze pg_stat_statements

Built for DBAs, by a DBA. What do you need next? thepostgresguy.com

Giovanni Martinez Mar 17

I took a little break, but I'm excited to be back sharing with you all.
Here’s what I’ve been working on lately—can’t wait for your thoughts!
Check it out and let me know what you think!
Read here:
https://dub.sh/dkXim1l

Giovanni Martinez Mar 15

I’m thrilled to join the AWS Community Builders 2026 cohort! 🎉☁️
My first official deep dive is live. "Postgres=tables, Mongo=docs" is a myth. At scale, it's really about MVCC write amplification vs. WiredTiger Copy-on-Write.
Read the internal trade-offs here: https://dub.sh/L60SfSH
#AWSCommunityBuilders #AWS #PostgreSQL #MongoDB #DatabaseArchitecture

Giovanni Martinez Feb 15

I've spent a lot of time thinking about how tough it is to keep our data safe.
Each setup—on-prem, hybrid, or cloud—has its own security headaches, and it's not always clear which is the trickiest.
Each setup—on-prem, hybrid, or cloud—has its own security challenges.
Personally, I find hybrid setups trickiest because of juggling different policies and controls.
What’s your experience?

Giovanni Martinez Feb 14

I always find myself choosing between a detailed HTML report and a quick terminal summary.
What do you prefer when checking your test results?
I really like seeing a clear summary of my test results, but sometimes a visual report helps me spot issues faster.
What works best for you? Let me know your thoughts!

Giovanni Martinez Feb 13

I’ve tried a few different operating systems for managing databases, and each one has its own perks.
Curious—what do you use for your database projects?
I use MacOS for most of my database work because it feels stable and flexible.
What OS do you prefer for database management?
Let me know in the comments!

Giovanni Martinez Feb 12

Enhancing update performance by avoiding index modification when the updated column isn't part of any index. This relies heavily on "Page Pruning" to clean up dead tuples on the fly without a full VACUUM.
This is the difference between a database that scales and one that chokes on write amplification.
Check out the book: https://dub.sh/RNV0WzR And join the upcoming event: https://dub.sh/S0Vsj3W
#Postgresql #Internals #HOTUpdates

PostgreSQL Internals Mastery: A Comprehensive Guide

Deep dive into PostgreSQL 18 internals. Master the process model, memory layers, and groundbreaking Asynchronous I/O to build high-performance systems.

Giovanni Martinez Feb 11

MongoDB performance often gets oversimplified. We've all heard "just index it," but that ignores the nuance of execution stages.
I'm tuning 𝗶𝗾𝘁𝗼𝗼𝗹𝗸𝗶𝘁 to dig into the actual damage: pinpointing if a query is dying during the Scan, Sort, or Fetch phase.
The goal is a tool that acts as a second opinion:
- Identify the query shape.
- Highlight the bottleneck stage.
- Suggest the fix.
If you could automate one specific insight for MongoDB, what would it be?
#MongoDB #iqtoolkit #Database