pg_toast.pg_toast_relfilenode not exist due to vacuum full tablename

From: walker <failaway(at)qq(dot)com>
To: pgsql-hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: pg_toast.pg_toast_relfilenode not exist due to vacuum full tablename
Date: 2022-09-10 04:53:30
Message-ID: tencent_6FFEDF9F75530AE28AA0CD16203BCC254209@qq.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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&nbsp; 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&nbsp; 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&nbsp; --- it's ok, the toast table exists
vacuum full reymont;
\d+ pg_toast.pg_toast_relfilenode&nbsp; --- 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Justin Pryzby 2022-09-10 05:01:43 Re: pg15b4: FailedAssertion("TransactionIdIsValid(xmax)
Previous Message Zhang Mingli 2022-09-10 04:07:30 Re: pg15b4: FailedAssertion("TransactionIdIsValid(xmax)