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: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin

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

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) ?



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-2017 The PostgreSQL Global Development Group