Re: multi billion row tables: possible or insane? - Mailing list pgsql-performance

From Josh Berkus
Subject Re: multi billion row tables: possible or insane?
Date
Msg-id 200503011711.18571.josh@agliodbs.com
Whole thread Raw
In response to multi billion row tables: possible or insane?  (Ramon Bastiaans <bastiaans@sara.nl>)
List 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

pgsql-performance by date:

Previous
From: Gaetano Mendola
Date:
Subject: Re: Inheritence versus delete from
Next
From: Tom Lane
Date:
Subject: Re: Confusion about locales and 'like' indexes