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
8 rows affected
7 rows affected
identifier | persons |
---|---|
1 | {1,2,3} |
2 | {4} |
3 | {5} |
4 | {6,7} |
5 | {8} |
identifier | persons |
---|---|
1 | {3,2,1} |
2 | {4} |
3 | {5} |
4 | {7,6} |
5 | {8} |
identifier | persons | rooms |
---|---|---|
1 | {1,2,3} | {1} |
2 | {4} | {2,3,4} |
3 | {5} | {5} |
4 | {6,7} | {6} |
5 | {8} | {7} |
identifier | persons | rooms |
---|---|---|
1 | {3,2,1} | {1,1,1} |
2 | {4,4,4} | {4,3,2} |
3 | {5} | {5} |
4 | {7,6} | {6,6} |
5 | {8} | {7} |