📊 PostgreSQL Query Optimization in action at #P2D2! Henrietta Dombrovskaya leads a workshop on writing efficient queries—reading execution plans, choosing the right indexes, and more. All wrapped up with the Ultimate Optimization Algorithm. 🚀🐘
#PostgreSQL #QueryOptimization #DatabasePerformance
#PostgreSQL #QueryOptimization #DatabasePerformance
January 27, 2026 at 9:27 AM
📊 PostgreSQL Query Optimization in action at #P2D2! Henrietta Dombrovskaya leads a workshop on writing efficient queries—reading execution plans, choosing the right indexes, and more. All wrapped up with the Ultimate Optimization Algorithm. 🚀🐘
#PostgreSQL #QueryOptimization #DatabasePerformance
#PostgreSQL #QueryOptimization #DatabasePerformance
Queries slow down at scale—but they don’t have to.
Cole Bowden explains how we optimize query performance for TB-scale workloads using distributed query execution and smart shuffle optimization.
👉 youtu.be/Ue42afyaU_0
#DataEngineering #QueryOptimization #SQLPerformance
Cole Bowden explains how we optimize query performance for TB-scale workloads using distributed query execution and smart shuffle optimization.
👉 youtu.be/Ue42afyaU_0
#DataEngineering #QueryOptimization #SQLPerformance
Distributed query processing in Firebolt
YouTube video by Firebolt
youtu.be
December 4, 2024 at 10:49 AM
Queries slow down at scale—but they don’t have to.
Cole Bowden explains how we optimize query performance for TB-scale workloads using distributed query execution and smart shuffle optimization.
👉 youtu.be/Ue42afyaU_0
#DataEngineering #QueryOptimization #SQLPerformance
Cole Bowden explains how we optimize query performance for TB-scale workloads using distributed query execution and smart shuffle optimization.
👉 youtu.be/Ue42afyaU_0
#DataEngineering #QueryOptimization #SQLPerformance
2/ Vlad Mihalcea's guide leverages Releem to supercharge MySQL query performance for Spring Boot apps. 💪 #QueryOptimization
July 16, 2025 at 5:01 PM
2/ Vlad Mihalcea's guide leverages Releem to supercharge MySQL query performance for Spring Boot apps. 💪 #QueryOptimization
"🗄️ DB Tip of the Day: Optimize queries by using EXPLAIN to analyze query plans and identify bottlenecks 📈 #QueryOptimization"
July 11, 2026 at 11:42 AM
"🗄️ DB Tip of the Day: Optimize queries by using EXPLAIN to analyze query plans and identify bottlenecks 📈 #QueryOptimization"
"🗄️ DB Tip of the Day: Regularly analyze and optimize database queries to reduce latency, improve performance, and enhance user experience ⏱️ #QueryOptimization"
June 4, 2026 at 8:48 AM
"🗄️ DB Tip of the Day: Regularly analyze and optimize database queries to reduce latency, improve performance, and enhance user experience ⏱️ #QueryOptimization"
Day 1 spotlight! 🌟
🕘 9:00 – Hettie Dombrovskaya: Learn how to write efficient queries
🕜 13:30 – Josef Machytka: Learn everything about #PGBouncer
▶️ Don’t miss these!
#PostgreSQL #PGDay #PPDD #QueryOptimization #DatabasePerformance
🕘 9:00 – Hettie Dombrovskaya: Learn how to write efficient queries
🕜 13:30 – Josef Machytka: Learn everything about #PGBouncer
▶️ Don’t miss these!
#PostgreSQL #PGDay #PPDD #QueryOptimization #DatabasePerformance
January 22, 2026 at 10:41 AM
Day 1 spotlight! 🌟
🕘 9:00 – Hettie Dombrovskaya: Learn how to write efficient queries
🕜 13:30 – Josef Machytka: Learn everything about #PGBouncer
▶️ Don’t miss these!
#PostgreSQL #PGDay #PPDD #QueryOptimization #DatabasePerformance
🕘 9:00 – Hettie Dombrovskaya: Learn how to write efficient queries
🕜 13:30 – Josef Machytka: Learn everything about #PGBouncer
▶️ Don’t miss these!
#PostgreSQL #PGDay #PPDD #QueryOptimization #DatabasePerformance
Guide to optimizing Oracle SQL via execution plans: fix full scans, joins, sorting with indexing & examples #queryoptimization
Optimizing Oracle Database Queries Using Execution Plans: A Step-by-Step Guide
hackernoon.com
February 3, 2025 at 9:26 PM
Guide to optimizing Oracle SQL via execution plans: fix full scans, joins, sorting with indexing & examples #queryoptimization
"🗄️ DB Tip of the Day: Improve query performance by using appropriate JOIN types (e.g., LEFT JOIN for optional matching, INNER JOIN for mandatory matching) and avoiding unnecessary joins 🔍 #QueryOptimization"
July 8, 2026 at 11:43 AM
"🗄️ DB Tip of the Day: Improve query performance by using appropriate JOIN types (e.g., LEFT JOIN for optional matching, INNER JOIN for mandatory matching) and avoiding unnecessary joins 🔍 #QueryOptimization"
Thanks for the amazing work to the whole team!
Joint work between Università degli Studi della Basilicata (Enzo Veltri, Donatello Santoro, Dario Satriani) and EURECOM (Sara Rosato, Simone Varriale).
#SQL #DataManagement #QueryOptimization #AI #LLM #Databases #SIGMOD2025
Joint work between Università degli Studi della Basilicata (Enzo Veltri, Donatello Santoro, Dario Satriani) and EURECOM (Sara Rosato, Simone Varriale).
#SQL #DataManagement #QueryOptimization #AI #LLM #Databases #SIGMOD2025
May 5, 2025 at 6:03 PM
Thanks for the amazing work to the whole team!
Joint work between Università degli Studi della Basilicata (Enzo Veltri, Donatello Santoro, Dario Satriani) and EURECOM (Sara Rosato, Simone Varriale).
#SQL #DataManagement #QueryOptimization #AI #LLM #Databases #SIGMOD2025
Joint work between Università degli Studi della Basilicata (Enzo Veltri, Donatello Santoro, Dario Satriani) and EURECOM (Sara Rosato, Simone Varriale).
#SQL #DataManagement #QueryOptimization #AI #LLM #Databases #SIGMOD2025
🚀 Staff Software Engineer, Query (Optimization) @ MongoDB | United States (Remote) | Tech: C++, AWS/GCP/Azure, Distributed Systems | Salary: $151k‑$297k | Lead the rewrite of MongoDB’s core query optimizer in a distributed DB! aihackerjobs.com/company/mong... #MongoDB #C++ #QueryOptimization
June 1, 2026 at 3:03 PM
🚀 Staff Software Engineer, Query (Optimization) @ MongoDB | United States (Remote) | Tech: C++, AWS/GCP/Azure, Distributed Systems | Salary: $151k‑$297k | Lead the rewrite of MongoDB’s core query optimizer in a distributed DB! aihackerjobs.com/company/mong... #MongoDB #C++ #QueryOptimization
AIMindUpdate News!
Struggling with slow queries? Observability provides constant, deep insight into query performance! Learn how to optimize for speed and efficiency. #Observability #QueryOptimization #DatabasePerformance
Click here↓↓↓
aimindupdate.com/2025/10/09/u...
Struggling with slow queries? Observability provides constant, deep insight into query performance! Learn how to optimize for speed and efficiency. #Observability #QueryOptimization #DatabasePerformance
Click here↓↓↓
aimindupdate.com/2025/10/09/u...
Optimize Queries with Observability: A Deep Dive | AI News
Boost query performance! Learn how to use observability metrics, execution plans, and distributed tracing to optimize databases.
aimindupdate.com
October 9, 2025 at 7:00 AM
AIMindUpdate News!
Struggling with slow queries? Observability provides constant, deep insight into query performance! Learn how to optimize for speed and efficiency. #Observability #QueryOptimization #DatabasePerformance
Click here↓↓↓
aimindupdate.com/2025/10/09/u...
Struggling with slow queries? Observability provides constant, deep insight into query performance! Learn how to optimize for speed and efficiency. #Observability #QueryOptimization #DatabasePerformance
Click here↓↓↓
aimindupdate.com/2025/10/09/u...
Philip P. will be speaking at #sqlsatBoston
SQL Server Memory Management. Memory clerks, and other creatures.
👇
⏰ Register soon to avoid being on the waiting list:
lnkd.in/enDxaxQk
#sqlsaturday #sqlserver #performancetuning #queryoptimization #memorymanagement #azuresql
SQL Server Memory Management. Memory clerks, and other creatures.
👇
⏰ Register soon to avoid being on the waiting list:
lnkd.in/enDxaxQk
#sqlsaturday #sqlserver #performancetuning #queryoptimization #memorymanagement #azuresql
August 22, 2023 at 2:01 PM
Philip P. will be speaking at #sqlsatBoston
SQL Server Memory Management. Memory clerks, and other creatures.
👇
⏰ Register soon to avoid being on the waiting list:
lnkd.in/enDxaxQk
#sqlsaturday #sqlserver #performancetuning #queryoptimization #memorymanagement #azuresql
SQL Server Memory Management. Memory clerks, and other creatures.
👇
⏰ Register soon to avoid being on the waiting list:
lnkd.in/enDxaxQk
#sqlsaturday #sqlserver #performancetuning #queryoptimization #memorymanagement #azuresql
🚀 Debugging Materialize with Materialize 🚀
Materialize now exposes source maps, mapping runtime metrics to high-level operators.
✅ Pinpoint bottlenecks
✅ Get EXPLAIN ANALYZE insights
✅ Tune TopK queries efficiently
Deep dive: bit.ly/3Eq2l4g
#databases #queryoptimization #Materialize
Materialize now exposes source maps, mapping runtime metrics to high-level operators.
✅ Pinpoint bottlenecks
✅ Get EXPLAIN ANALYZE insights
✅ Tune TopK queries efficiently
Deep dive: bit.ly/3Eq2l4g
#databases #queryoptimization #Materialize
Source Mapping and Introspection: Debugging Materialize with Materialize
Materialize now exposes source maps in its catalog, so you can build your own debugging queries that attribute performance characteristics to high-level operators.
bit.ly
February 5, 2025 at 2:04 PM
🚀 Debugging Materialize with Materialize 🚀
Materialize now exposes source maps, mapping runtime metrics to high-level operators.
✅ Pinpoint bottlenecks
✅ Get EXPLAIN ANALYZE insights
✅ Tune TopK queries efficiently
Deep dive: bit.ly/3Eq2l4g
#databases #queryoptimization #Materialize
Materialize now exposes source maps, mapping runtime metrics to high-level operators.
✅ Pinpoint bottlenecks
✅ Get EXPLAIN ANALYZE insights
✅ Tune TopK queries efficiently
Deep dive: bit.ly/3Eq2l4g
#databases #queryoptimization #Materialize
SQL Query Optimization 2026: 7 einfache Techniken fuer schnellere Datenbank-Performance
Sieben praktische SQL-Query-Optimierungstechniken fuer schnellere Datenbank-Performance, mit PostgreSQL-Beispielen fuer JOINs, IN-Listen, EXISTS, Datumsbereiche, Aggregati…
#sql #database #queryoptimization
Sieben praktische SQL-Query-Optimierungstechniken fuer schnellere Datenbank-Performance, mit PostgreSQL-Beispielen fuer JOINs, IN-Listen, EXISTS, Datumsbereiche, Aggregati…
#sql #database #queryoptimization
SQL Query Optimization 2026: 7 einfache Techniken fuer schnellere Datenbank-Performance
Sieben praktische SQL-Query-Optimierungstechniken fuer schnellere Datenbank-Performance, mit PostgreSQL-Beispielen fuer JOINs, IN-Listen, EXISTS, Datumsbereiche, Aggregationen und Deduplizierung.
www.alekseialeinikov.com
July 8, 2026 at 7:21 PM
SQL Query Optimization 2026: 7 einfache Techniken fuer schnellere Datenbank-Performance
Sieben praktische SQL-Query-Optimierungstechniken fuer schnellere Datenbank-Performance, mit PostgreSQL-Beispielen fuer JOINs, IN-Listen, EXISTS, Datumsbereiche, Aggregati…
#sql #database #queryoptimization
Sieben praktische SQL-Query-Optimierungstechniken fuer schnellere Datenbank-Performance, mit PostgreSQL-Beispielen fuer JOINs, IN-Listen, EXISTS, Datumsbereiche, Aggregati…
#sql #database #queryoptimization
SQL Query Optimization in 2026: 7 Simple Techniques for Faster Database Performance
Seven practical SQL query optimization techniques for faster database performance, with PostgreSQL-focused examples for joins, IN lists, EXISTS, date ranges, aggregates, an…
#sql #database #queryoptimization
Seven practical SQL query optimization techniques for faster database performance, with PostgreSQL-focused examples for joins, IN lists, EXISTS, date ranges, aggregates, an…
#sql #database #queryoptimization
SQL Query Optimization in 2026: 7 Simple Techniques for Faster Database Performance
Seven practical SQL query optimization techniques for faster database performance, with PostgreSQL-focused examples for joins, IN lists, EXISTS, date ranges, aggregates, and deduplication.
www.alekseialeinikov.com
July 6, 2026 at 4:39 PM
SQL Query Optimization in 2026: 7 Simple Techniques for Faster Database Performance
Seven practical SQL query optimization techniques for faster database performance, with PostgreSQL-focused examples for joins, IN lists, EXISTS, date ranges, aggregates, an…
#sql #database #queryoptimization
Seven practical SQL query optimization techniques for faster database performance, with PostgreSQL-focused examples for joins, IN lists, EXISTS, date ranges, aggregates, an…
#sql #database #queryoptimization
"🗄️ DB Tip of the Day: Optimize slow queries by using EXPLAIN ANALYZE (for PostgreSQL), EXPLAIN (for MySQL), and the execution plan in Management Studio (for SQL Server) ⏱️ #QueryOptimization"
July 2, 2026 at 8:44 AM
"🗄️ DB Tip of the Day: Optimize slow queries by using EXPLAIN ANALYZE (for PostgreSQL), EXPLAIN (for MySQL), and the execution plan in Management Studio (for SQL Server) ⏱️ #QueryOptimization"
Monkey Tools' TimeSleuth allows you to time all the queries in your #BusinessIntelligence solution, or just specific queries using the Detailed Refresh option. ⏱ It provides a detailed list of the refresh times as it goes. Learn how at mkyt.ca/timesleuth
#Excel #PowerQuery #QueryOptimization
#Excel #PowerQuery #QueryOptimization
July 2, 2025 at 4:36 PM
Monkey Tools' TimeSleuth allows you to time all the queries in your #BusinessIntelligence solution, or just specific queries using the Detailed Refresh option. ⏱ It provides a detailed list of the refresh times as it goes. Learn how at mkyt.ca/timesleuth
#Excel #PowerQuery #QueryOptimization
#Excel #PowerQuery #QueryOptimization
Nice:
“Extensible Query Optimizers In Practice” [2024, PDF], Bailu Ding, et al (www.microsoft.com/en-us/resear...).
#RDBMS #DB #QueryOptimizer #Paper #eBook #Survey #Databases #QueryOptimization
“Extensible Query Optimizers In Practice” [2024, PDF], Bailu Ding, et al (www.microsoft.com/en-us/resear...).
#RDBMS #DB #QueryOptimizer #Paper #eBook #Survey #Databases #QueryOptimization
www.microsoft.com
February 15, 2025 at 1:01 PM
Nice:
“Extensible Query Optimizers In Practice” [2024, PDF], Bailu Ding, et al (www.microsoft.com/en-us/resear...).
#RDBMS #DB #QueryOptimizer #Paper #eBook #Survey #Databases #QueryOptimization
“Extensible Query Optimizers In Practice” [2024, PDF], Bailu Ding, et al (www.microsoft.com/en-us/resear...).
#RDBMS #DB #QueryOptimizer #Paper #eBook #Survey #Databases #QueryOptimization
“Why SQLite Uses Bytecode”, D. Richard Hipp (sqlite.org/draft/whybyt...).
On HN: news.ycombinator.com/item?id=4020...
On Lobsters: lobste.rs/s/g2tl3w/why...
#SQLite #Databases #Compiler #AST #Bytecode #VirtualMachine #Parsing #QueryOptimization #ExecutionPlan #SQL
On HN: news.ycombinator.com/item?id=4020...
On Lobsters: lobste.rs/s/g2tl3w/why...
#SQLite #Databases #Compiler #AST #Bytecode #VirtualMachine #Parsing #QueryOptimization #ExecutionPlan #SQL
Why SQLite Uses Bytecode
8 comments
lobste.rs
May 1, 2024 at 1:32 PM
“Why SQLite Uses Bytecode”, D. Richard Hipp (sqlite.org/draft/whybyt...).
On HN: news.ycombinator.com/item?id=4020...
On Lobsters: lobste.rs/s/g2tl3w/why...
#SQLite #Databases #Compiler #AST #Bytecode #VirtualMachine #Parsing #QueryOptimization #ExecutionPlan #SQL
On HN: news.ycombinator.com/item?id=4020...
On Lobsters: lobste.rs/s/g2tl3w/why...
#SQLite #Databases #Compiler #AST #Bytecode #VirtualMachine #Parsing #QueryOptimization #ExecutionPlan #SQL
Boosting RAG search relevance often starts with query optimization. Generating synthetic queries and re-writing user inputs are powerful techniques to significantly enhance result accuracy. Don't underestimate the input! 💡 #QueryOptimization 2/5
October 21, 2025 at 4:00 PM
Boosting RAG search relevance often starts with query optimization. Generating synthetic queries and re-writing user inputs are powerful techniques to significantly enhance result accuracy. Don't underestimate the input! 💡 #QueryOptimization 2/5
Avoid non-sargable queries! Applying functions to indexed columns forces full table scans, killing performance. Instead, use indexed computed columns or case-insensitive collations for efficient filtering. #QueryOptimization 4/6
October 19, 2025 at 4:00 PM
Avoid non-sargable queries! Applying functions to indexed columns forces full table scans, killing performance. Instead, use indexed computed columns or case-insensitive collations for efficient filtering. #QueryOptimization 4/6
SQL index things I wish I knew earlier:
🔹 B-tree = sorted phone book
🔹 Clustered = table IS the index
🔹 5 indexes = 6 writes per INSERT
🔹 Low cardinality → planner skips it
🔹 Column order in composite = design decision
open.substack.com/pub/nishankm...
#SQL #DataEngineering #QueryOptimization
🔹 B-tree = sorted phone book
🔹 Clustered = table IS the index
🔹 5 indexes = 6 writes per INSERT
🔹 Low cardinality → planner skips it
🔹 Column order in composite = design decision
open.substack.com/pub/nishankm...
#SQL #DataEngineering #QueryOptimization
SQL Indexing Internals: What No One Tells You Until Your Query Takes 40 Seconds
The query was fine yesterday.
open.substack.com
May 1, 2026 at 11:54 AM
SQL index things I wish I knew earlier:
🔹 B-tree = sorted phone book
🔹 Clustered = table IS the index
🔹 5 indexes = 6 writes per INSERT
🔹 Low cardinality → planner skips it
🔹 Column order in composite = design decision
open.substack.com/pub/nishankm...
#SQL #DataEngineering #QueryOptimization
🔹 B-tree = sorted phone book
🔹 Clustered = table IS the index
🔹 5 indexes = 6 writes per INSERT
🔹 Low cardinality → planner skips it
🔹 Column order in composite = design decision
open.substack.com/pub/nishankm...
#SQL #DataEngineering #QueryOptimization