01 - PostgreSQL 17/18: What's New and Performance Improvements
PostgreSQL 17/18: Novita e Miglioramenti Performance PostgreSQL rimane il database relazionale open-source piu avanzato del mondo, e le versioni 17 e 18...
Database Engineering
Series “Database Engineering”: it starts with “02 - EXPLAIN ANALYZE: Read and Optimize Query Plans”. EXPLAIN ANALYZE: Read and Optimize Query Plans PostgreSQL A query that takes 8 seconds in production can often be optimized to 50ms with the right index strategy. Learn to read query plans, identify bottlenecks, and…
This series collects 3 articles (approximately 44 minutes of total reading time), designed for a level Intermediate. The main topics covered are PostgreSQL 17, PostgreSQL 18, performance, novita.
3Articles44 minTotal reading timeIntermediateLevel
PostgreSQL 17PostgreSQL 18performancenovitabenchmarkEXPLAIN ANALYZE
Series Articles
- 1
- 2
02 - EXPLAIN ANALYZE: Read and Optimize Query Plans
EXPLAIN ANALYZE: Read and Optimize Query Plans PostgreSQL A query that takes 8 seconds in production can often be optimized to 50ms with the right index strategy. Learn to read query plans, identify bottlenecks, and choose optimal join algorithms.
- 3
03 - Advanced Indexing: Partial, Covering, BRIN, GIN
Indexing Avanzato PostgreSQL: Partial, Covering, BRIN e GIN Un indice B-Tree su una colonna e la soluzione per l'80% dei problemi di performance.