Should We Defragment Indexes? - A Deep Dive into Modern Disk Architecture and I/O Performance
Explore modern disk architecture and I/O dynamics to understand when index defragmentation may hinder performance, challenging conventional practices.
Empowering SQL - Mastering Intelligent Query Processing in 20 Minutes
Optimize database performance with Intelligent Query Processing. Explore key features and real-world impacts in SQL Server and Azure SQL for accelerated query efficiency.
A Rails Performance Guidebook: From 0 to 1 Billion Requests per Day
Discover patterns, strategies, and tricks to enhance Rails app performance, drawing from real-world experiences of scaling to billions of daily requests.
Implementing Native Composite Primary Key Support in Rails 7.1
Explore composite primary keys in Rails 7.1, optimize applications, and enhance database performance with this powerful new feature.
Awesome SQL – Tips and Tricks for Application Developers
Discover advanced SQL techniques for modern application development, including window functions, CTEs, JSON handling, and efficient pagination methods to enhance query performance and functionality.
Dungeons, Dragons, and Graph Databases
Explore graph databases through a D&D-inspired example. Learn to model complex relationships, write efficient queries, and optimize data structures for adventurous problem-solving.
Best Practices in PostgreSQL Tuning - Navigating Key Performance Bottlenecks in the Cloud
Optimize PostgreSQL performance in cloud environments through practical techniques for diagnosing and solving common bottlenecks, enhancing database efficiency and health.
NORM: No ORM Framework - Efficient Data Transfer Between Applications and Databases
Explore NORM: a framework for efficient database-application communication without ORM pitfalls. Learn to build "transport objects" for optimized data transfer.
How PostgreSQL Aggregates Work and How to Create and Use Custom Aggregates
Explore PostgreSQL aggregates' inner workings, create custom aggregates, and optimize their use for enhanced database performance and functionality.
Advanced Postgres Schema Design for Scalable Application Development
Explore advanced PostgreSQL features for scalable schema design, including functional indexes, exclusion constraints, and array types.
PostgreSQL Query Performance Insights
Gain insights into PostgreSQL query performance patterns using tools like pg_stat_activity, pg_stat_statements, auto_explain, pgBadger, and pg_stat_monitor for effective measurement, analysis, and optimization.
You Have 2 Seconds to Respond - Atob
Explore techniques for optimizing Rails application response times, focusing on rapid user interactions and performance enhancements.
Beyond CRUD: PostgreSQL Techniques Your Rails App Is Missing
Explore advanced PostgreSQL techniques for Rails apps, including locking mechanisms and mutex, to enhance scalability and prevent production outages.
Using Postgres and OpenAI to Power Your AI Recommendation Engine - RailsConf 2024
Discover how to build and optimize an AI recommendation engine using Rails, Postgres, and OpenAI. Learn scaling techniques for handling unique AI data needs.
The Very Hungry Transaction - Avoiding Risky Database Patterns
Explore how database transactions grow into liabilities, uncover problematic patterns, and learn strategies to maintain data integrity and database health.
Performance Audits - The Top 8 Problems We Find and How to Fix Them
Discover the 8 most common performance issues in web development and learn effective strategies to resolve them for optimal site speed and user experience.
Extending Postgres Capabilities with Rust - Teaching an Old Dog New Tricks
Explore PostgreSQL extensibility with Rust using pgrx. Build, test, and deploy a real extension. Learn how custom extensions can simplify legacy code and improve query performance.
OtterTune: AI-Powered Database Optimization as a Service
Explore AI-powered database optimization with OtterTune, revolutionizing performance tuning through machine learning and automation.
User-Defined Function Optimizations in Advanced Database Systems - Lecture 11
Explore advanced optimization techniques for user-defined functions in database systems, enhancing query performance and system efficiency.
Optimizing Apache HoraeDB for High-Cardinality Metrics at AntGroup
Discover optimization techniques for handling high-cardinality metrics in Apache HoraeDB, featuring real-world implementation strategies from AntGroup's engineering experience.