growing disk usage problem: alternative solution?

Поиск
Список
Период
Сортировка
От wu_zhong_min@vrane.com
Тема growing disk usage problem: alternative solution?
Дата
Msg-id 20070626184824.247B7238C0@web.a
обсуждение исходный текст
Ответы Re: growing disk usage problem: alternative solution?  ("Joshua D. Drake" <jd@commandprompt.com>)
Re: growing disk usage problem: alternative solution?  (Bill Moran <wmoran@potentialtech.com>)
Список pgsql-general
Hello List

I have been a user since 7.x version.  My current server version is 8.1.2.

As many of you know the disk usage keeps growing for postgresql unless one regularly reindex and/or fully vacuum.  The
problemwith either method is that they lock the tables and it is not practical for databases that one wants to keep it
availablefor 24x7x365 basis.  For very large tables, while the tables are being reindexed, there will be many waiting
update/delete/insertprocesses and this is not at all desirable. 

Server response is still great even with growing disk usage.  Any one has other ideas to check the growth of the disk
usage.

Please do not cc the response to me.  I will read it in the list.

Sincerely

Z-m Wu

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

Предыдущее
От: "Talha Khan"
Дата:
Сообщение: Re: A problem in inheritance
Следующее
От: "Willy-Bas Loos"
Дата:
Сообщение: Re: escaped rolenames in pg_has_role