Re: Should a DB vacuum use up a lot of space ?

Поиск
Список
Период
Сортировка
От Philippe Girolami
Тема Re: Should a DB vacuum use up a lot of space ?
Дата
Msg-id 8F4598C0-4F7B-4348-BA26-53B11F4176B9@mosaik.com
обсуждение исходный текст
Ответ на Re: Should a DB vacuum use up a lot of space ?  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: Should a DB vacuum use up a lot of space ?
Список pgsql-general
@Adrian, no problem ! I’m sure someone else will run into this and have the same questions, hopefully they’ll find the
answers.

I am seeing something weird though (again, this is v9.1): after my database became usable again, I started getting the
10Mwarning on template0. So I made it connectable and ran VACUUM FREEZE on it and made it unconnectable again. That
resolvethe warning.
 

However, I see the “age” keeps increasing on that database as I ran queries on my own db. Yesterday the age was 32 and
nowit’s already 77933902
 
Is that to be expected ? I didn’t expect it

Thanks
 


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

Предыдущее
От: Andreas Joseph Krogh
Дата:
Сообщение: Re: Updated RUM-index and support for bigint as part of index
Следующее
От: Andreas Joseph Krogh
Дата:
Сообщение: Re: Updated RUM-index and support for bigint as part of index