-
Notifications
You must be signed in to change notification settings - Fork 828
Open
Labels
Description
Describe the bug
After I put toast_tuple_target on the materialized view, I don't see toast_tuple_target in the properties window.
ALTER TABLE test_mv SET (toast_tuple_target = 128);
To Reproduce
Steps to reproduce the behavior:
- Run SQL commands
CREATE TABLE test AS
SELECT generate_series(1,1000) AS id, REPEAT('a', 8000) AS descr;
CREATE MATERIALIZED VIEW test_mv AS (
SELECT * FROM test WHERE id > 5
);
ALTER TABLE test_mv SET (toast_tuple_target = 128);
REFRESH MATERIALIZED VIEW test_mv;
- Go to
Materialized Views->test_mv->Right click->Properties->Definitiontab - I don't see the field
toast_tuple_targetin the definition tab - I cannot modify
toast_tuple_targetin the definition tab
Expected behavior
I should see the toast_tuple_target field in the definition tab, and I should modify it.
Screenshots
Desktop (please complete the following information):
- OS: Windows 11 x64
- pgAdmin 9.12
- Mode: Desktop
- Browser Google Chrome
- Package type: pgadmin4-9.12-x64.exe
- Postgresql 18.1
Additional context
psql / pg_dump shows everything fine
#psql test=# \d+ test_mv
Materialized view "public.test_mv"
Column | Type | Collation | Nullable | Default | Storage | Compression | Stats target | Description
--------+---------+-----------+----------+---------+----------+-------------+--------------+-------------
id | integer | | | | plain | | |
descr | text | | | | extended | | |
View definition:
SELECT id,
descr
FROM test
WHERE id > 5;
Access method: heap
Options: toast_tuple_target=128
#pg_dump -Upostgres -t test_mv --schema-only test
CREATE MATERIALIZED VIEW public.test_mv
WITH (toast_tuple_target='128') AS
SELECT id,
descr
FROM public.test
WHERE (id > 5)
WITH NO DATA;
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
Type
Projects
Status
No status