#queryperformance — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #queryperformance, aggregated by home.social.
-
Interesting problem of a huge query requesting 2TB of memory "by accident"
-
It seems #Microsoft deliberately cripples the abilities of their #Postgres offering, especially when it comes to parallel query. I can't explain otherwise why their Azure hosting is consistently (substantially) slower than our low-end VM with identical data and configuration.
-
#throwback Think EXPLAIN tells the whole story? 👀 Ants Aasma reveals the hidden performance gremlins PostgreSQL plans don’t show—TOAST lookups, visibility checks, hint bits, and more. Learn how to spot what’s slowing you down.
▶️ Watch now! https://www.youtube.com/watch?v=y07-VLh7Sxc&list=PL_m-TUcr7ZvnSBmPoxZvcB1lfy7C9eced&index=12
-
👨💻🎩 "Evan Schwartz just discovered that #SQLite indexes exist and now thinks he's a #database wizard. 🎉 Despite his 'subtle' revelation, he managed to improve query performance by 35%, proving that even a broken clock is right twice a day." 🤦♂️
https://emschwartz.me/subtleties-of-sqlite-indexes/ #DatabaseWizard #QueryPerformance #TechHumor #HackerNews #ngated -
👨💻🎩 "Evan Schwartz just discovered that #SQLite indexes exist and now thinks he's a #database wizard. 🎉 Despite his 'subtle' revelation, he managed to improve query performance by 35%, proving that even a broken clock is right twice a day." 🤦♂️
https://emschwartz.me/subtleties-of-sqlite-indexes/ #DatabaseWizard #QueryPerformance #TechHumor #HackerNews #ngated -
👨💻🎩 "Evan Schwartz just discovered that #SQLite indexes exist and now thinks he's a #database wizard. 🎉 Despite his 'subtle' revelation, he managed to improve query performance by 35%, proving that even a broken clock is right twice a day." 🤦♂️
https://emschwartz.me/subtleties-of-sqlite-indexes/ #DatabaseWizard #QueryPerformance #TechHumor #HackerNews #ngated -
👨💻🎩 "Evan Schwartz just discovered that #SQLite indexes exist and now thinks he's a #database wizard. 🎉 Despite his 'subtle' revelation, he managed to improve query performance by 35%, proving that even a broken clock is right twice a day." 🤦♂️
https://emschwartz.me/subtleties-of-sqlite-indexes/ #DatabaseWizard #QueryPerformance #TechHumor #HackerNews #ngated