Re: > 16TB worth of data question

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jeremiah Jahn <jeremiah(at)cs(dot)earlham(dot)edu>
Cc: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>, postgres list <pgsql-general(at)postgresql(dot)org>
Subject: Re: > 16TB worth of data question
Date: 2003-04-22 01:43:10
Message-ID: 18788.1050975790@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jeremiah Jahn <jeremiah(at)cs(dot)earlham(dot)edu> writes:
> The only issue with this is that it is difficult to recomend to our
> clients who depend on bob and cuz'n joe to support their hardware.

And you expect them to be successful running a database that acquires
2TB+ of data per year? I think you need to recalibrate your
expectations. Consumer-grade junk PCs do not have the reliability
to make such a project even worth starting. Run the database on decent
made-to-be-a-server hardware, or you'll regret it.

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Wenzhe Zhou 2003-04-22 02:36:57 index file corrupted
Previous Message Tom Lane 2003-04-22 01:28:36 Re: postgresql doesn't start