Re: VACUUM FULL doesn't reduce table size

Поиск
Список
Период
Сортировка
От pinker
Тема Re: VACUUM FULL doesn't reduce table size
Дата
Msg-id 1425910117681-5841110.post@n5.nabble.com
обсуждение исходный текст
Ответ на Re: VACUUM FULL doesn't reduce table size  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: VACUUM FULL doesn't reduce table size  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: VACUUM FULL doesn't reduce table size  (Kevin Grittner <kgrittn@ymail.com>)
Список pgsql-general
I did: select pg_cancel_backend(pid) from pg_stat_activity where usename <>
'mine';

and then tried again vacuum full:

INFO:  vacuuming "my_table"
INFO:  "my_table": found 0 removable, 3043947 nonremovable row versions in
37580 pages
DETAIL:  0 dead row versions cannot be removed yet.
CPU 1.07s/1.56u sec elapsed 3.24 sec.
Query returned successfully with no result in 6436 ms.


PostgreSQL 9.3.5 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.8.2
20140120 (Red Hat 4.8.2-16), 64-bit

It was flash copy snapshot



--
View this message in context: http://postgresql.nabble.com/VACUUM-FULL-doesn-t-reduce-table-size-tp5840782p5841110.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Creating composite keys from csv
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: VACUUM FULL doesn't reduce table size