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.
[ Parent
| on HN ]
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.