Episodi

  • Why Your Database Needs a Concurrent Backup Strategy

    Why Your Database Needs a Concurrent Backup Strategy
    Jun 9 2026
    Episode 40 of Database Tech with Fexingo dives into the overlooked risks of database backups under concurrent workloads. Lucas explains how PostgreSQL's `pg_dump` can cause hidden performance degradation when run during peak hours, citing a real-world case where a fintech platform saw query latency spike 300% due to backup-induced lock contention. Luna brings up MySQL's Percona XtraBackup and the trade-offs between physical and logical backups. Together they explore why a concurrent backup strategy—using tools like `pg_basebackup` or WAL archiving—is critical for high-availability systems in mid-2026. Specific, actionable, and backed by numbers. #DatabaseBackups #ConcurrentBackups #PostgreSQL #MySQL #pg_dump #WALArchiving #PerconaXtraBackup #LockContention #HighAvailability #FintechCaseStudy #QueryLatency #BackupStrategy #DataEngineering #TechPodcast #DatabaseTechWithFexingo #FexingoBusiness #BusinessPodcast #ITOperations Keep every episode free: buymeacoffee.com/fexingo
    Mostra di più Mostra meno
    8 min
  • Why Database Scaling Fails Without Query Analysis

    Why Database Scaling Fails Without Query Analysis
    Jun 8 2026
    In this episode, Lucas and Luna dive into the silent killer of database performance: unoptimized queries that go unnoticed until the database is under real load. They examine a real-world case where a company's PostgreSQL instance ground to a halt because a single query was scanning millions of rows every five seconds — and how enabling pg_stat_statements and analyzing query patterns turned a 30-second query into 50 milliseconds. The hosts discuss why most teams focus on hardware scaling before looking at query behavior, the difference between sequential scans and index scans, and three practical steps to start query analysis today. Perfect for engineers, data architects, and anyone who's ever watched a database melt down during a traffic spike. #DatabaseScaling #QueryAnalysis #PostgreSQL #pg_stat_statements #SlowQueries #DatabasePerformance #SQL #Indexing #SequentialScan #DatabaseOptimization #BackendEngineering #DataEngineering #TechPodcast #DatabaseTips #PerformanceTuning #FexingoBusiness #BusinessPodcast #Technology Keep every episode free: buymeacoffee.com/fexingo
    Mostra di più Mostra meno
    8 min
  • Why Database Connectionless Architecture Is the Future

    Why Database Connectionless Architecture Is the Future
    Jun 8 2026
    In Episode 38 of Database Tech with Fexingo, Lucas and Luna explore the emerging concept of connectionless database architectures. Using CockroachDB and Google Cloud Spanner as concrete examples, they explain how eliminating persistent TCP connections can reduce latency, improve scalability, and simplify connection management for modern distributed systems. The hosts discuss the HTTP/gRPC-based request model, compare it to traditional connection pooling, and weigh the trade-offs in consistency and complexity. A must-listen for engineers evaluating next-gen database designs. #ConnectionlessArchitecture #CockroachDB #GoogleCloudSpanner #DatabaseDesign #DistributedSystems #HTTP #gRPC #ConnectionPooling #Scalability #Latency #TechPodcast #DatabaseTech #SQL #NoSQL #DataStorage #Engineering #FexingoBusiness #BusinessPodcast Keep every episode free: buymeacoffee.com/fexingo
    Mostra di più Mostra meno
    10 min
  • Why Database Stored Procedures Still Matter in 2026

    Why Database Stored Procedures Still Matter in 2026
    Jun 7 2026
    In this episode of Database Tech with Fexingo, Lucas and Luna explore why stored procedures—once considered legacy—are seeing a resurgence in modern cloud databases. They break down a real-world case from a mid-sized e-commerce company that cut query latency by 40 percent by moving critical order-processing logic into stored procedures. The discussion covers when to use them, the trade-offs with application-layer logic, and why the rise of serverless and edge computing is changing the calculus. No fluff, just a concrete look at a forgotten tool that still delivers. Perfect for engineers and architects evaluating database design patterns in 2026. #StoredProcedures #Database #SQL #Tech #Technology #DatabaseTech #FexingoBusiness #BusinessPodcast #CloudDatabases #Serverless #EdgeComputing #QueryPerformance #EcommerceTech #DatabaseOptimization #LegacyTech #SoftwareEngineering #DataArchitecture #DatabaseDesign Keep every episode free: buymeacoffee.com/fexingo
    Mostra di più Mostra meno
    11 min
  • Why Database Indexes Become a Performance Problem

    Why Database Indexes Become a Performance Problem
    Jun 7 2026
    Lucas and Luna explore a counterintuitive database performance issue: indexes that actually slow queries down. They examine how B-tree index depth grows with data volume, turning fast lookups into multi-level tree traversals. The discussion uses a concrete example of a 10-million-row table on PostgreSQL and shows how a poorly chosen composite index on an e-commerce orders table caused query times to jump from 2 milliseconds to over 200 milliseconds after a schema migration. They explain index fragmentation, the impact of high-cardinality columns, and why write-heavy workloads suffer from index maintenance overhead. Practical tuning advice includes using pg_stat_user_indexes to spot unused indexes and considering partial indexes for skewed data distributions. The episode closes with a reminder that indexes are not set-and-forget—they need periodic review. #DatabaseIndexes #PostgreSQL #BTree #QueryPerformance #IndexTuning #DatabaseOptimization #CompositeIndex #IndexFragmentation #Cardinality #PartialIndex #pg_stat_user_indexes #WriteHeavyWorkloads #Technology #DatabaseTech #FexingoBusiness #BusinessPodcast #SQL #DataStorage Keep every episode free: buymeacoffee.com/fexingo
    Mostra di più Mostra meno
    8 min
  • Why Database Connection Latency Spikes Under Load

    Why Database Connection Latency Spikes Under Load
    Jun 6 2026
    Lucas and Luna explore why database connection latency can suddenly spike from 2 milliseconds to over 200 milliseconds under heavy load, even when the database itself isn't saturated. They examine a real-world case from a mid-sized e-commerce platform where connection establishment overhead — TCP handshakes, TLS negotiation, authentication — became the bottleneck after a routine deployment. Lucas explains how connection pooling mitigates this but why pool size tuning and keepalive settings matter more than most engineers realize. Luna challenges the common assumption that adding more connections helps, revealing how connection storms can cascade into latency disasters. The episode covers specific tools like pgBouncer for PostgreSQL, connection multiplexing strategies, and why monitoring connection establishment time is more important than query execution time for many applications. A practical deep dive for anyone who has ever seen application latency degrade without obvious database performance issues. #Database #Technology #ConnectionLatency #PostgreSQL #pgBouncer #ConnectionPooling #TCPHandshake #TLSNegotiation #DatabasePerformance #LatencySpikes #ConnectionStorm #BackendEngineering #SQL #NoSQL #DataEngineering #FexingoBusiness #BusinessPodcast #TechPodcast Keep every episode free: buymeacoffee.com/fexingo
    Mostra di più Mostra meno
    8 min
  • Why Database Caching Strategies Break Under Write-Heavy Workloads

    Why Database Caching Strategies Break Under Write-Heavy Workloads
    Jun 6 2026
    On this episode of Database Tech with Fexingo, Lucas and Luna dig into why caching — a go-to performance fix — can actually harm your database under write-heavy workloads. They break down the invalidation problem using a concrete example: a social media platform tracking daily active users. Lucas explains how a naive time-to-live cache can return stale data for hours, while Luna pushes back on the common 'just use Redis' mindset. They explore cache-aside, write-through, and write-back strategies, revealing why the latter introduces serious crash risks. The hosts also tie the discussion to real-world trade-offs at companies like Uber and Twitter, where read-heavy vs. write-heavy patterns demand totally different caching architectures. No ad break, no fluff — just a focused 10-minute conversation on one specific database design decision that can make or break application performance. #Database #Caching #WriteHeavyWorkloads #CacheInvalidation #CacheAside #WriteThrough #WriteBack #Redis #TimeToLive #DatabasePerformance #DataEngineering #TechPodcast #FexingoBusiness #BusinessPodcast #DatabaseTech #SQL #NoSQL #LucasAndLuna Keep every episode free: buymeacoffee.com/fexingo
    Mostra di più Mostra meno
    7 min
  • Why Your Database Timeouts Are Silent Performance Killers

    Why Your Database Timeouts Are Silent Performance Killers
    Jun 5 2026
    In this episode of Database Tech with Fexingo, Lucas and Luna dive into the hidden costs of database timeouts—specifically, why the default timeout values in most application frameworks are dangerously high. Using a real-world case from a mid-sized e-commerce company that saw a 40% drop in checkout completion after a traffic spike, they explain how timeouts compound under load, how to calculate the right timeout for your workload, and why connection pool exhaustion often gets misdiagnosed as a database bottleneck. No fluff, just actionable guidance for developers and ops teams who need their databases to survive Black Friday without falling over. #DatabaseTimeouts #ConnectionPooling #BackendPerformance #PostgreSQL #MySQL #NodeJS #Golang #EcommerceTech #BlackFriday #DatabaseBestPractices #SoftwareEngineering #TechOps #PerformanceTuning #RelationalDatabases #FexingoBusiness #BusinessPodcast #TechPodcast #DatabaseTech Keep every episode free: buymeacoffee.com/fexingo
    Mostra di più Mostra meno
    8 min