Requirements for a database server

From: Robert(dot)Farrugia(at)go(dot)com(dot)mt
To: pgsql-admin(at)postgresql(dot)org
Subject: Requirements for a database server
Date: 2001-07-18 05:52:37
Message-ID: OF9B71CB14.FAFF2342-ONC1256A8D.001FE4C0@go.com.mt
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

I have been using postgres for the last year now. The database has grown
from a mere few MBs to over 100GB data and expected to top up 300GB by the
end of the year. Lately performance of queries, inserts, updates has
continued to grow worse as the dataset has grown larger, even though most
queries have indexes on them, while vacuuming the database has become a
nightmare. For this reason we were thinking of upgrading the system
hardware.

Is there anyone out there who has databases of this sort ? Can he point me
out some basic requirements for these sort of databases (processors, ram,
storage, etc) ? Also would it be worthwile to migrate to another database
system which is more robust with this kind of amount of data (such as
oracle) ?

Thanks
Robert

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Markwalder Philip 2001-07-18 07:33:22 Re: Problem: plperl load failed (PGSQL 7.1.2)
Previous Message SUVRANSHU KAR 2001-07-18 03:10:16 Re: HOW-TO migrate database