Postgres 15

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?.

select version();

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 test 
(
  x TEXT NOT NULL
);

CREATE TABLE

INSERT INTO test VALUES ('abc');

INSERT 0 1

SELECT
  REGEXP_REPLACE(x, '<something>', '<something_else>', 'g')
FROM test

regexp_replace

abc

SELECT 1

-- RESULT: ABC