Re: Requirements for a database server

Currently we are using a PowerEdge 2400 server, 1 Gb RAM, dual-processor.
We have 5 x 36GB SCSI disks at RAID 5 for the database and one 36GB disk
for the WAL files, logging , os, etc.

Postgres configuration is set to
sort_mem = 65536
fsync = false
shared_buffers = 1000

The database consist of 6 main tables (plus some other additional ones,
which are not that large, but used in joins with main table).
Largest table consists of almost 15GB of data (spread over 15 files). It
has four main indexes comprising another 13GB of data.

As operating system we're using Redhat 7.1 with the SMP kernel.

Regards
Robert

"Andy Samuel"
<andysamuel(at)geoc To: <Robert(dot)Farrugia(at)go(dot)com(dot)mt>
ities.com> cc:
Subject: Re: [ADMIN] Requirements for a database server
18/07/2001 10:06

Robert

The size of your db makes me very interested. May I know your currrent
computer configuration ( Processor, memory, etc ) ? And also the
configuration of your PostgreSQL.
Please feel free you post them at the ADMIN forum since it will be very
useful to others.

Best regards
Andy

----- Original Message -----
From: <Robert(dot)Farrugia(at)go(dot)com(dot)mt>
To: <pgsql-admin(at)postgresql(dot)org>
Sent: Wednesday, July 18, 2001 12:52 PM
Subject: [ADMIN] Requirements for a database server

> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://www.postgresql.org/search.mpl