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?.
2 rows affected
gid | line |
---|---|
1 | LINESTRING(0 0,1 0) |
1 | LINESTRING(1 0,1 1) |
1 | LINESTRING(1 1,0 1) |
2 | LINESTRING(3 4,5 6) |
2 | LINESTRING(5 6,7 8) |
2 | LINESTRING(7 8,9 10) |
gid | line |
---|---|
1 | LINESTRING(0 0,1 0) |
1 | LINESTRING(1 0,1 1) |
1 | LINESTRING(1 1,0 1) |
2 | LINESTRING(3 4,5 6) |
2 | LINESTRING(5 6,7 8) |
2 | LINESTRING(7 8,9 10) |
gid | line |
---|---|
1 | LINESTRING(0 0,1 0) |
1 | LINESTRING(1 0,1 1) |
1 | LINESTRING(1 1,0 1) |
2 | LINESTRING(3 4,5 6) |
2 | LINESTRING(5 6,7 8) |
2 | LINESTRING(7 8,9 10) |