Re: multi billion row tables: possible or insane?

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Ramon Bastiaans <bastiaans(at)sara(dot)nl>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: multi billion row tables: possible or insane?
Date: 2005-03-02 01:11:18
Message-ID: 200503011711.18571.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Ramon,

> What would be important issues when setting up a database this big, and
> is it at all doable? Or would it be a insane to think about storing up
> to 5-10 billion rows in a postgres database.

What's your budget? You're not going to do this on a Dell 2650. Do you
have the kind of a budget necessary to purchase/build a good SAN,
Quad-opteron machine, etc.? Or at least hire some tuning help?

--
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2005-03-02 01:42:14 Re: Confusion about locales and 'like' indexes
Previous Message Gaetano Mendola 2005-03-02 00:56:52 Re: Inheritence versus delete from