Re: disk usage spike

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: disk usage spike
Дата
Msg-id 24609.1155003164@sss.pgh.pa.us
обсуждение исходный текст
Ответ на disk usage spike  (Geoff Parker <geoffparkernews@yahoo.ca>)
Ответы Re: disk usage spike  (Geoff Parker <geoffparkernews@yahoo.ca>)
Список pgsql-admin
Geoff Parker <geoffparkernews@yahoo.ca> writes:
> I have a database with about 155GB of binary data in large objects and 15GB of data in other tables.  In compressed
form,it consumes about 60GB on disk.  On friday, the amount of disk usage increased to 240GB (over a period of 5
minutes),stayed at 240GB for 2 days, and then returned to 60GB (again over a period of about 5 minutes). 

It's impossible to say much with only that amount of information.  If we
knew what part of the database had bloated (table? index? WAL log?) we
could perhaps offer some wisdom.  Next time, use "du" and and related
tools to see where the space went.

            regards, tom lane

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

Предыдущее
От: "Benjamin Krajmalnik"
Дата:
Сообщение: Strange UTF8 issue with pg_dump/pg_restore
Следующее
От: Geoff Parker
Дата:
Сообщение: Re: disk usage spike