Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group