Programming, Sql, Postgresql, Performance, Data Engineering.
optimization, since it changes the logic to exit early. We had to be sure that we hadn't added a subtle bug back into the query. Simple check was to simple do a count(*) on both the slow and fast queries on many different sets of data. Then, for a small subset of data, I manually verified that all