pg_statistics bloat after drop table

Поиск
Список
Период
Сортировка
От hubert depesz lubaczewski
Тема pg_statistics bloat after drop table
Дата
Msg-id 20130530112106.GA28955@depesz.com
обсуждение исходный текст
Список pgsql-bugs
Tested on todays HEAD of 9.3.

Steps to reproduce:


$ create table t1 (i int4);
CREATE TABLE

$ insert into t1 (i) values (1);
INSERT 0 1

$ analyze t1;
ANALYZE

$ select count(*) from pg_statistic where starelid = 't1'::regclass;
 count
-------
     1
(1 row)

$ create table t2 () inherits (t1);
CREATE TABLE

$ analyze t1;
ANALYZE

$ select count(*) from pg_statistic where starelid = 't1'::regclass;
 count
-------
     2
(1 row)

$ drop table t2;
DROP TABLE

$ analyze t1;
ANALYZE

$ select count(*) from pg_statistic where starelid = 't1'::regclass;
 count
-------
     2
(1 row)

I think that the additional row (with stainherit = true) should be deleted.

Best regards,

depesz

--
The best thing about modern society is how easy it is to avoid contact with it.
                                                             http://depesz.com/

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Khamphousone Bounkong
Дата:
Сообщение: Re: BUG #8183: field timestamp result to date
Следующее
От: vishnu.singh@sunarctechnologies.com
Дата:
Сообщение: BUG #8190: Issue with slony-I replication on postgres master and slave database