Re: Requirements for a database server

From: "Ross J(dot) Reedstrom" <reedstrm(at)rice(dot)edu>
To: Robert(dot)Farrugia(at)go(dot)com(dot)mt
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Requirements for a database server
Date: 2001-07-18 15:10:04
Message-ID: 20010718101004.C25319@rice.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Robert -
You mention having a PostgreSQL database in production for around a year.
May I ask what version it is? I'm guessing you're still at 6.5.X,
in which case, I'd suggest an upgrade to 7.1.2, before doing anything
more drastic. Not only are there bug fixes, many improving stability
of the system, there are also performance enhancements, particularly in
scalability. Without knowing more details of your schema and applications
(typical queries, table sizes, etc.) we can't be of much more help.

BTW, we've had many reports of multi-gigabyte systems performing well,
and recently a report of a multi-TERA-byte system!

There have been lots of vacuum changes, as well: Bruce and Tom have made
VACUUM much friendlier to a live system since 6.5.x.

Ross

On Wed, Jul 18, 2001 at 07:52:37AM +0200, Robert(dot)Farrugia(at)go(dot)com(dot)mt wrote:
> 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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message DAVID LIZANO MARCO 2001-07-18 15:23:14 Re: Compile directive -8k limit
Previous Message Edipo Elder Fernandes de Melo 2001-07-18 14:47:19 Password file for autent