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?.
CREATE TABLE t (name text);
INSERT INTO t VALUES
('Richard'),('John'),('Peter'),('Bob');
CREATE TABLE
INSERT 0 4
SELECT ROW_NUMBER() OVER (),name FROM t;
| row_number | name |
|---|---|
| 1 | Richard |
| 2 | John |
| 3 | Peter |
| 4 | Bob |
SELECT 4
SELECT name||'_'||ROW_NUMBER() OVER () FROM t;
| ?column? |
|---|
| Richard_1 |
| John_2 |
| Peter_3 |
| Bob_4 |
SELECT 4