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 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
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) |