Re: VACUUM FULL doesn't reduce table size

Поиск
Список
Период
Сортировка
От pinker
Тема Re: VACUUM FULL doesn't reduce table size
Дата
Msg-id 1425913536570-5841123.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
Re: VACUUM FULL doesn't reduce table size
Список pgsql-general
select * from pg_stat_activity where state ilike 'idle in transaction%' it's
empty.

>And there is no relation between this table and the tables or functions
being queried?

no...

>If  snapshot is what I think it means, you might want to point them at:

>http://www.postgresql.org/docs/9.3/interactive/backup-file.html

hmmm, maybe it's because WAL is in another tablespace?



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


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

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