growing disk usage problem: alternative solution?

From: wu_zhong_min(at)vrane(dot)com
To: pgsql-general(at)postgresql(dot)org
Subject: growing disk usage problem: alternative solution?
Date: 2007-06-26 18:48:23
Message-ID: 20070626184824.247B7238C0@web.a
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 problem with either method is that they lock the tables and it is not practical for databases that one wants to keep it available for 24x7x365 basis. For very large tables, while the tables are being reindexed, there will be many waiting update/delete/insert processes 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Willy-Bas Loos 2007-06-26 19:19:24 Re: escaped rolenames in pg_has_role
Previous Message Talha Khan 2007-06-26 17:49:02 Re: A problem in inheritance