News for hackers. Stuff that matters.
Re:My Favorite PostgreSQL Queries and Why They Matter by sk5t on Saturday April 14, 2018 @10:59PM (#16840884)
Yup! The simple UPDATEs could improve the chances of the query planner working optimally--think of cases where a single, complex, setwise update might avoid using some really helpful partial indexes, etc.
Re:My Favorite PostgreSQL Queries and Why They Matter by billrobertson42 on Sunday April 15, 2018 @12:02AM (#16841125)
And would also improve the chances that somebody looking at the sql in 5 or 10 years would quickly understand it as well.