pg_toast.pg_toast_relfilenode not exist due to vacuum full tablename
От | walker |
---|---|
Тема | pg_toast.pg_toast_relfilenode not exist due to vacuum full tablename |
Дата | |
Msg-id | tencent_6FFEDF9F75530AE28AA0CD16203BCC254209@qq.com обсуждение исходный текст |
Ответы |
Re: pg_toast.pg_toast_relfilenode not exist due to vacuum full tablename
|
Список | pgsql-hackers |
hi,
this morning i met an issue, that after vacuum full tablename, the associated toast table shows not exist.
here is the operation steps:
drop table if exists reymont;
create table reymont ( id bigint primary key, data bytea not null);
alter table reymont alter column data set compression pglz;
insert into reymont values(1, pg_read_binary_file('filename'));
vacuum full reymont;
select relname, relfilenode, reltoastrelid from pg_class where relname='reymont';
\d+ pg_toast.pg_toast_relfilenode
Did not find any relation named "pg_toast.pg_toast_relfilenode".
however, if display toast table before vacuum full operation, no problem.
drop table if exists reymont;
create table reymont ( id bigint primary key, data bytea not null);
alter table reymont alter column data set compression pglz;
insert into reymont values(1, pg_read_binary_file('filename'));
\d+ pg_toast.pg_toast_relfilenode --- it's ok, the toast table exists
vacuum full reymont;
\d+ pg_toast.pg_toast_relfilenode --- it's ok, the toast table exists
it looks a little strange, any ideas? appreciate your help.
env:
pg14.4
linux 3.10.0-693.17.1.e17
thanks
walker
В списке pgsql-hackers по дате отправления: