By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.
5 rows affected
| device_id | brand_affiliation | blacklisted_tags | blacklisted_brands |
|---|---|---|---|
| device1 | A Mart | {Shopping} | {Amazon,Walmart} |
| device_id | brand_affiliation | blacklisted_tags | blacklisted_brands |
|---|---|---|---|
| device1 | A Mart | {Shopping} | {Amazon,Walmart} |
| device2 | {} | {} | |
| device3 | {Food} | {} | |
| device4 | {} | {Samsung} | |
| device5 | McD | {Food} | {"Burger King",KFC} |
4 rows affected
| ad_id | tags | brand |
|---|---|---|
| ad1 | {Food,Drink} | Burger King |
| ad2 | {Phone} | Samsung |
| ad3 | {Appliances} | Samsung |
| ad4 | {Appliances} | LG |
| device_id | brand_affiliation | blacklisted_tags | blacklisted_brands |
|---|---|---|---|
| device1 | A Mart | {Shopping} | {Amazon,Walmart} |
| device2 | {} | {} | |
| device3 | {Food} | {} | |
| device4 | {} | {Samsung} | |
| device5 | McD | {Food} | {"Burger King",KFC} |