Postgres 16

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 extension pg_trgm;

CREATE EXTENSION


CREATE TABLE phrases (
  id SERIAL NOT NULL PRIMARY KEY,
  phrase TEXT NOT NULL DEFAULT ''
);

CREATE TABLE


INSERT INTO phrases(phrase)
VALUES 
  ('подвыподверт'), ('палеонтология'), ('хуеплет');

INSERT 0 3


SELECT 
  phrase, 
  similarity(phrase, 'выпад') AS "выпад", 
  similarity(phrase, 'хуй') AS "хуй",
  similarity(phrase, 'логика') AS "логика"
FROM phrases;


phrase
выпад
хуй
логика


подвыподверт
0.0625
0
0

палеонтология
0
0
0.10526316

хуеплет
0
0.2
0



SELECT 3

phrase	выпад	хуй	логика
подвыподверт	0.0625	0	0
палеонтология	0	0	0.10526316
хуеплет	0	0.2	0