Re: [pgsql-advocacy] Postgres and really huge tables

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: [pgsql-advocacy] Postgres and really huge tables
Дата
Msg-id 200701191604.13850.josh@agliodbs.com
обсуждение исходный текст
Ответ на Re: [pgsql-advocacy] Postgres and really huge tables  (Chris Mair <chris@1006.org>)
Список pgsql-performance
> A lot of data, but not a lot of records... I don't know if that's
> valid. I guess the people at Greenplum and/or Sun have more exciting
> stories ;)

Not really.   Pretty much multi-terabyte tables are fine on vanilla
PostgreSQL if you can stick to partitioned and/or indexed access.  If you
need to do unindexed fishing expeditions on 5tb of data, then talk to
Greenplum.

http://www.powerpostgresql.com/Downloads/terabytes_osc2005.pdf

--
--Josh

Josh Berkus
PostgreSQL @ Sun
San Francisco

В списке pgsql-performance по дате отправления:

Предыдущее
От: Kevin Hunter
Дата:
Сообщение: Re: DB benchmark and pg config file help
Следующее
От: "Simon Riggs"
Дата:
Сообщение: Re: Table Inheritence and Partioning