minus-squaretrampel@feddit.orgtoPostgreSQL@programming.dev•Foreign Data Wrappers turned my Postgres into a universal query engine, and I kinda love itlinkfedilinkarrow-up2·3 months agoI have noticed much better performance when using with-clauses while fetching data from remote data sources. By selecting all the remote tabes first and only then joining local tables the resulting explain plans got much better. linkfedilink
I have noticed much better performance when using with-clauses while fetching data from remote data sources. By selecting all the remote tabes first and only then joining local tables the resulting explain plans got much better.