We can't find the internet
Attempting to reconnect
Something went wrong!
Hang in there while we get back on track
Hans-Jürgen Schönig: Performance tricks you have never seen before 2.0 (PGConf.EU 2023)
Discover revolutionary performance tricks at PGConf.EU 2023, where Hans-Jürgen Schönig shares expert insights on reducing planning time, increasing memory, and controlling scale-up, highlighting the importance of a tailored approach to optimization.
- Performance debugging is about reducing planning time, increasing memory, and controlling scale-up.
- Logically, reducing planning time makes a significant difference in performance.
- Taking control of planning time can lead to massive reduction in planning time.
- Reducing planning time can be achieved by reducing data sizes, indexing, and tweaking join orders.
- The planning time can affect performance when dealing with many joins.
- In the process of optimizing, do not lose sight of the core purpose.
- The speaker highlights that subtractive approach to optimization is not wrong, but neglecting the core purpose.
- The use of scale-up button should be minimized and not mistaken as a solution.
- Optimizing performance requires careful consideration of many factors.
- Loading libraries before use can be beneficial.
- Reducing data sizes can also help in optimization.
- Indexing and preloading libraries can also contribute to optimization.
- There is no one-size-fits-all optimization technique, and each situation requires a tailored approach.