Re: [OFF-TOPIC] - Known maximum size of the PostgreSQL

Поиск
Список
Период
Сортировка
Искать
От
J. Andrew Rogers
Тема
Re: [OFF-TOPIC] - Known maximum size of the PostgreSQL
Дата
в 18:11:49
Msg-id
1083791489.11496.23.camel@localhost.localdomain
Ответ на
Список
Дерево обсуждения
[OFF-TOPIC] - Known maximum size of the PostgreSQL Database "Carlos Eduardo Smanioto" <csmanioto@uol.com.br>
Re: [OFF-TOPIC] - Known maximum size of the PostgreSQL "J. Andrew Rogers" <jrogers@neopolitan.com>
Re: [OFF-TOPIC] - Known maximum size of the PostgreSQL Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Re: [OFF-TOPIC] - Known maximum size of the PostgreSQL Richard Huxton <dev@archonet.com>
Re: [OFF-TOPIC] - Known maximum size of the PostgreSQL Shridhar Daithankar <shridhar@frodo.hserus.net>
Re: [pgsql-advocacy] [OFF-TOPIC] - Known maximum size of Gavin Sherry <swm@linuxworld.com.au>
Re: [OFF-TOPIC] - Known maximum size of the Don Vaillancourt <donv@webimpact.com>
Re: [OFF-TOPIC] - Known maximum size of the Gaetano Mendola <mendola@bigfoot.com>
Re: [OFF-TOPIC] - Known maximum size of the PostgreSQL "scott.marlowe" <scott.marlowe@ihs.com>
On Sat, 2004-06-05 at 11:55, Carlos Eduardo Smanioto wrote:
> What's the case of bigger database PostgreSQL (so greate and amount of
> registers) that they know???


You might want to fix the month on your system time.

With respect to how big PostgreSQL databases can get in practice, these
are our two biggest implementations:

- 0.5 Tb GIS database (this maybe upwards of 600-700Gb now, I didn't
check)

- 10 Gb OLTP system with 70 million rows and a typical working set of
2-3 Gb.


Postgres is definitely capable of handling large pretty databases with
ease.  There are some narrow types of workloads that it doesn't do so
well on, but for many normal DBMS loads it scales quite well.


j. andrew rogers


В списке pgsql-performance по дате отправления
От: Carlos Eduardo Smanioto
Дата:
От: scott.marlowe
Дата:
FAQ