CREATE VIEW my$view AS
    SELECT relname, relkind, pg_get_relationopt(oid) AS reloptions,
         pg_relation_size(oid) / current_setting('block_size')::int AS relpages
    FROM pg_class WHERE relname LIKE 'my$%' ORDER BY relkind, relname;


CREATE TABLE my$tbl (i int) WITH (fillfactor=50);
CREATE INDEX my$btree ON my$tbl USING btree (i) WITH (fillfactor=50);
INSERT INTO my$tbl SELECT generate_series(1, 100000);

CHECKPOINT;
SELECT * FROM my$view;

/* [expected]
 relname  | relkind |  reloptions   | relpages 
----------+---------+---------------+----------
 my$btree | i       | fillfactor=50 |      494
 my$tbl   | r       | fillfactor=50 |     1087
 my$view  | v       |               |        0
(3 rows)
*/

ALTER TABLE my$tbl SET (fillfactor = 100);
ALTER INDEX my$btree SET (fillfactor = 100);
CLUSTER my$btree ON my$tbl; -- it also does REINDEX.

CHECKPOINT;
SELECT * FROM my$view;

/* [expected]
 relname  | relkind |   reloptions   | relpages 
----------+---------+----------------+----------
 my$btree | i       | fillfactor=100 |      249
 my$tbl   | r       | fillfactor=100 |      541
 my$view  | v       |                |        0
(3 rows)
*/
