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?.
version |
---|
PostgreSQL 15.0 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-10), 64-bit |
SELECT 1
CREATE TABLE
INSERT 0 10
alphanumeric_id |
---|
8d9edd33c9 |
f98df7e9b2 |
f8502c5530 |
ba47ef34fa |
e6546a22cd |
1a950c0397 |
6cd65e73b4 |
7003c4b161 |
e7fb2517e0 |
8591b11424 |
SELECT 10
CREATE SEQUENCE
ALTER TABLE
alphanumeric_id | numeric_id |
---|---|
8d9edd33c9 | null |
f98df7e9b2 | null |
f8502c5530 | null |
ba47ef34fa | null |
e6546a22cd | null |
1a950c0397 | null |
6cd65e73b4 | null |
7003c4b161 | null |
e7fb2517e0 | null |
8591b11424 | null |
SELECT 10
UPDATE 10
alphanumeric_id | numeric_id |
---|---|
8d9edd33c9 | 1 |
f98df7e9b2 | 2 |
f8502c5530 | 3 |
ba47ef34fa | 4 |
e6546a22cd | 5 |
1a950c0397 | 6 |
6cd65e73b4 | 7 |
7003c4b161 | 8 |
e7fb2517e0 | 9 |
8591b11424 | 10 |
SELECT 10