Postgres 16

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE tbl (id int, title text);

INSERT INTO tbl VALUES
  (1, 'title1')
, (2, 'title2')
, (3, 'title1')
, (4, 'title13')
, (5, 'title4')
, (6, 'title7')
, (7, 'title1')
, (8, 'title1')
, (9, 'title53')
, (10, 'title11')
, (11, 'title1')
;

CREATE TABLE



INSERT 0 11


WITH cte AS (
   SELECT DISTINCT ON (title)
          title, id
   FROM   tbl
   ORDER  BY title, id
   )
SELECT *
FROM   cte
ORDER  BY id
LIMIT  3
OFFSET 3;


title
id


title4
5

title7
6

title53
9



SELECT 3


CREATE MATERIALIZED VIEW mv_tbl AS
SELECT DISTINCT ON (title)
       title, id
FROM   tbl
ORDER  BY title, id;

CREATE UNIQUE INDEX mv_tbl_uniq ON mv_tbl (id) INCLUDE (title);

SELECT 7



CREATE INDEX


SELECT *
FROM   mv_tbl
ORDER  BY id
LIMIT  3
OFFSET 3;


title
id


title4
5

title7
6

title53
9



SELECT 3