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 по дате отправления: