Re: multi billion row tables: possible or insane?

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: multi billion row tables: possible or insane?
Дата
Msg-id 200503011711.18571.josh@agliodbs.com
обсуждение исходный текст
Ответ на multi billion row tables: possible or insane?  (Ramon Bastiaans <bastiaans@sara.nl>)
Список 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 по дате отправления:

Предыдущее
От: Gaetano Mendola
Дата:
Сообщение: Re: Inheritence versus delete from
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Confusion about locales and 'like' indexes