Events  Deals  Jobs  NFT NYC 2024 
    Sign in  
 
 
 
 
              

      
 
Sign up for our awesome New York
Tech Events weekly email newsletter.
   
EVENT DETAILS
Right execution plans can deliver maximum performance & throughput from your PostgreSQL database. It is important to understand all factors which affect the execution plan which includes costing, datatypes, indexing, filter & join conditions, pruning, runtime exclusions, etc. Poor understanding of the planner leads to suboptimal performance. There are substantial improvements in new versions of PostgreSQL which everyone should be aware about. This is a talk + small demonstrations of few cases how plan changes/behaves. This talk covers improvements in PostgreSQL 12. 1. Overview of Planner 2. Factors affecting the plan: costing 3. Selection of paths 4. Prepared statements & plan cache. 5. How plan changes with PostgreSQL versions. 6. Automatic elimination of unwanted joins. 7. CTE & Its optimization covering the latest improvements 8. Partition pruning 9. Run time optimizations 10. Optimizer support for functions, COST clause of CREATE FUNCTION
 
 
 
 
© 2024 GarysGuide      About    Feedback    Press    Terms