Re: > 16TB worth of data question

From: Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my>
To: Jeremiah Jahn <jeremiah(at)cs(dot)earlham(dot)edu>
Cc: postgres list <pgsql-general(at)postgresql(dot)org>
Subject: Re: > 16TB worth of data question
Date: 2003-04-22 15:31:09
Message-ID: 5.2.1.1.1.20030422231702.0231a6b8@mbox.jaring.my
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

At 08:13 AM 4/22/2003 -0500, Jeremiah Jahn wrote:
>That's the question...That 2 TB of data is nothing but documents and
>images. I'm under the perception that if that gets parked on a fibre
>channel disk array/ SAN the data will be pretty safe, and the server
>mostly replaceable at that time. Storage is my worry more than
>processing power. I don't think I'm on crack here...?

How about backups? Backing up 2-16TB needs a bit more planning and design.

> > I think I've spent more time chasing various people's hardware failures
> > lately than I have in investigating real Postgres bugs. I keep
> > volunteering to look at failures because I figure there are still some
> > data-loss bugs to be found, but I am coming to have a *real* low opinion
> > of off-the-shelf PC hardware.
> >
> > regards, tom lane

Well there's off-the-shelf x86 desktop PC hardware, and there's
off-the-shelf x86 server hardware.

In my experience for name brands it's about 1/7 DOA for the former, and 0
for the latter. There's a big diff in dependability. The latter tend to
keep running for many years, typically being retired for no fault of their own.

Then there are users who stick no name memory into their servers or "servers".

Regards,
Link.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message James Thompson 2003-04-22 15:32:50 Re: GUI from database schema?
Previous Message Thomas Kellerer 2003-04-22 15:21:53 Re: database browser