Date: 2023-06-01
Time: 11:00–11:45
Room: DMS 1160
Level: Intermediate
I introduce 3 new features in various stages of development
UNION DISTINCT ON (...) - a small extension to Recursive Queries which makes flowing shortest path searches easy and fast. Inspired by some last years Advent of Code tasks.
Loopback Connections - Want to connect back to your own database instance securely but without password - now you can!
Fixing slow TOAST - for multiple table layouts the current TOAST storage will really slow you down , getting sequential scan speeds in tens of megabytes per second where hardware can do a few GB/s. A mitigation using pl/proxy and loopback connections is shows, as well as a new "DIRECT TOAST" format which will fix the main bottlenecks.