bool / vacuum full bug followup
| От | Scott Marlowe |
|---|---|
| Тема | bool / vacuum full bug followup |
| Дата | |
| Msg-id | Pine.LNX.4.33.0205021624280.15253-100000@css120.ihs.com обсуждение исходный текст |
| Ответы |
Re: Subject: bool / vacuum full bug followup
Re: Subject: bool / vacuum full bug followup Re: Subject: bool / vacuum full bug followup |
| Список | pgsql-general |
OK, this is just beyond weird. I swear to GOD that my table size was
growing. I'm on a workstation that doesn't accept connections from
anybody but me.
I was running 7.2 for weeks.
I created a simple table:
create table test (buf text, yn bool);
I run an explain:
explain select * from test where yn=true;
I run an analyze:
analyze;
I update the table:
update test set yn=true where yn=true;
update test set yn=true where yn=true;
update test set yn=true where yn=true;
I do a REGULAR vacuum:
vacuum;
And after that, the table started growing after all vacuum fulls. I can't
reproduce it now. I blew away the table, recreated it, and now it doesn't
do that. I blew away the database, and installed 7.2.1 and it won't do
it. I reinstalled 7.2 and blew away the database and it still won't do
it.
So, I don't know why it WAS doing it, but it isn't now. And of course,
it's my personal workstation, so no log files. :-( I'll see if I can
reproduce this though, as I've seen similar problems pop up once in the
past with a seldom vacuumed database that reached a point where it stopped
freeing dead tuples. Very bothersome.
В списке pgsql-general по дате отправления: