From: | digoal(at)126(dot)com |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #14042: bug, PostgreSQL not cleanup temp table info after crash. |
Date: | 2016-03-24 08:45:08 |
Message-ID: | 20160324084508.2903.55060@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 14042
Logged by: digoal
Email address: digoal(at)126(dot)com
PostgreSQL version: 9.5.1
Operating system: CentOS 6.x x64
Description:
When PostgreSQL crashed during database have temp table, database not
cleanup the temp table's info in pg_class.
and there is some bad thing, if no one create the same name temp table after
restart. this temp table will a zombie in pg_class, and vacuum freeze cann't
reduce it's age and database's age.
test:
create temp table t(id int);
don't disconnect this session.
and then:
pg_ctl stop -m immediate
and then
pg_ctl start
and then
select * from pg_namespace;
select age(relfrozenxid),relname from pg_class where relname='t';
select txid_current();
generate some xid;
vauum freeze pg_temp_??.t;
and the table not reduce age.
select age(relfrozenxid),relname from pg_class where relname='t';
and database's age cann't reduce by
vacuum freeze;
From | Date | Subject | |
---|---|---|---|
Next Message | harada.toshi | 2016-03-24 09:49:44 | BUG #14043: log_line_prefix %h not expand.(RPM only) |
Previous Message | Haribabu Kommi | 2016-03-24 04:59:02 | Re: Breakage with VACUUM ANALYSE + partitions |