Very large database

From: Michael Welter <mike(at)introspect(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Very large database
Date: 2002-01-09 02:34:07
Message-ID: 3C3BAC1F.5050907@introspect.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I need some help here. We need to implement a 180+GB database with
120+MB of updates every evening. Rather than purchasing the big iron,
we would like to use postgres running over Linux 2.4.x as the data
server. Is this even possible? Who has the largest database out there
and what does it run on?

How should we implement the disk array? Should we purchase a hardware
RAID card or should we use the software RAID capabilities in Linux 2.4?
Should we consider a SMP system? Should we use an outboard RAID box
(like RaidZone)?

If anyone out there has implemented a database of this size then I would
like to correspond with you.

Thanks for your help,
Mike

Responses

Browse pgsql-general by date

  From Date Subject
Next Message cnliou 2002-01-09 03:55:49 Write/Read Encrypted Text
Previous Message Jason Earl 2002-01-09 00:41:33 Re: Query planner isn't using my indices