vacuum verbose analyze lazy problem.

Поиск
Список
Период
Сортировка
От Denis Perchine
Тема vacuum verbose analyze lazy problem.
Дата
Msg-id 0012142010240E.08541@dyp.perchine.com
обсуждение исходный текст
Список pgsql-hackers
Hello,

I just have installed Vadim's patch for speeding up vacuum.
And have quite strange problem.
I have quite small table:
[root@mx src]# ls -l /home/postgres/data/base/db/users*
-rw-------   1 postgres postgres  4120576 Dec 14 08:48 
/home/postgres/data/base/db/users
-rw-------   1 postgres postgres   483328 Dec 14 08:46 
/home/postgres/data/base/db/users_id_key
-rw-------   1 postgres postgres     8192 Dec 14 08:20 
/home/postgres/data/base/db/users_id_seq

I did vacuum verbose analyze lazy;, and it locks up (or better say do 
something for a long time.

Before started vacuuming users.
19379 pts/0    R      2:24 /home/postgres/bin/postgres localhost postgres 
db VACUUM

Before I kill the backend.
19379 pts/0    R      4:41 /home/postgres/bin/postgres localhost postgres 
db VACUUM

It spends at least 2 minutes trying vacuuming users. Usually this table is 
vacuumed & analyzed in few seconds.

Here is the output of vacuum verbose analyze, I done after this problem 
arises.

db=# vacuum verbose analyze users;
NOTICE:  --Relation users --
NOTICE:  Pages 978: Changed 1, reaped 832, Empty 0, New 0; Tup 14280: Vac 
13541, Keep/VTL 0/0, Crash 0, UnUsed 265, MinLen 248, MaxLen 340; Re-using: 
Free/Avail. Space 3891320/3854076; EndEmpty/Avail. Pages 0/666. CPU 
0.09s/1.25u sec.
NOTICE:  Index users_id_key: Pages 35; Tuples 14280: Deleted 82. CPU 
0.00s/0.05u sec.
NOTICE:  Index ix_users_account_name: Pages 56; Tuples 14280: Deleted 82. CPU 
0.01s/0.05u sec.
NOTICE:  Index ix_users_blocked: Pages 31; Tuples 14280: Deleted 82. CPU 
0.00s/0.05u sec.
NOTICE:  Rel users: Pages: 978 --> 503; Tuple(s) moved: 640. CPU 0.22s/0.22u 
sec.
NOTICE:  Index users_id_key: Pages 59; Tuples 14280: Deleted 640. CPU 
0.00s/0.04u sec.
NOTICE:  Index ix_users_account_name: Pages 93; Tuples 14280: Deleted 640. 
CPU 0.00s/0.04u sec.
NOTICE:  Index ix_users_blocked: Pages 32; Tuples 14280: Deleted 640. CPU 
0.00s/0.04u sec.
VACUUM

I wouldn't consider it's a bug, but from my point of view it is quite strange.
Any comments?

BTW, I did a backup, and can supply anyone interested with original table.

-- 
Sincerely Yours,
Denis Perchine

----------------------------------
E-Mail: dyp@perchine.com
HomePage: http://www.perchine.com/dyp/
FidoNet: 2:5000/120.5
----------------------------------


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

Предыдущее
От: Chris Ian Capon Fiel
Дата:
Сообщение: Re: PostgreSQL for Windows 98, 2000, NT
Следующее
От: Jan Wieck
Дата:
Сообщение: Re: Bug in FOREIGN KEY