How we seamlessly transitioned thousands of organizations to a group-based permissions system in a performance-sensitive application.| The Zulip Blog
DELETE DELETE — delete rows of a table Synopsis [ WITH [ RECURSIVE ] with_query [, ...] ] DELETE FROM …| PostgreSQL Documentation
Instead, let’s structure the query as a Common Table Expression and leverage the power of doing significantly less work to make things go faster. Using a CTE instead of a naive full table join cuts down our query time from 12 seconds to ~0.12 seconds!| Jaz’s Blog
SELECT SELECT, TABLE, WITH — retrieve rows from a table or view Synopsis [ WITH [ RECURSIVE ] with_query [, …| PostgreSQL Documentation