There are many reasons that affect the performance of the database. But it is often overlooked how well a well-written query can improve the performance of your database. With a well structured query, you can increase the performance of your database hundreds of times.
In this session you will find the answer to the following questions
- How do I write a well structured query? What is important tips?
- What are the important points to be considered in order for the query to come with performance?
- How should we rewrite query according to explain plan?
- How should we set the PostgreSQL parameters according to the explain plan of the query?
- Is the order of join and tables an important criterion when writing queries?
- Is the order of the index important in multi column indexes?
- How does a table without proper normalization affect the performance of the query?
- How much do the items I mentioned above affect performance in postgresql 13?
- What’s new about performance in Postgresql 14?