pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: [OFF-TOPIC] - Known maximum size of the PostgreSQL
5+ messages / 5 participants
[nested] [flat]
* Re: [OFF-TOPIC] - Known maximum size of the PostgreSQL
@ 2004-05-05 21:11 ` J. Andrew Rogers <jrogers@neopolitan.com>
2004-05-06 01:48 ` Re: [OFF-TOPIC] - Known maximum size of the PostgreSQL Christopher Kings-Lynne <chriskl@familyhealth.com.au>
1 sibling, 1 reply; 5+ messages in thread
From: J. Andrew Rogers @ 2004-05-05 21:11 UTC (permalink / raw)
To: Carlos Eduardo Smanioto <csmanioto@uol.com.br>; +Cc: pgsql-performance
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [OFF-TOPIC] - Known maximum size of the PostgreSQL
2004-05-05 21:11 ` Re: [OFF-TOPIC] - Known maximum size of the PostgreSQL J. Andrew Rogers <jrogers@neopolitan.com>
@ 2004-05-06 01:48 ` Christopher Kings-Lynne <chriskl@familyhealth.com.au>
2004-05-06 08:13 ` Re: [OFF-TOPIC] - Known maximum size of the PostgreSQL Richard Huxton <dev@archonet.com>
0 siblings, 1 reply; 5+ messages in thread
From: Christopher Kings-Lynne @ 2004-05-06 01:48 UTC (permalink / raw)
To: J. Andrew Rogers <jrogers@neopolitan.com>; +Cc: Carlos Eduardo Smanioto <csmanioto@uol.com.br>; pgsql-performance
>>What's the case of bigger database PostgreSQL (so greate and amount of
>>registers) that they know???
Didn't someone say that RedSheriff had a 10TB postgres database or
something?
Chris
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [OFF-TOPIC] - Known maximum size of the PostgreSQL
2004-05-05 21:11 ` Re: [OFF-TOPIC] - Known maximum size of the PostgreSQL J. Andrew Rogers <jrogers@neopolitan.com>
2004-05-06 01:48 ` Re: [OFF-TOPIC] - Known maximum size of the PostgreSQL Christopher Kings-Lynne <chriskl@familyhealth.com.au>
@ 2004-05-06 08:13 ` Richard Huxton <dev@archonet.com>
2004-05-06 08:43 ` Re: [PERFORM] [OFF-TOPIC] - Known maximum size of the PostgreSQL Shridhar Daithankar <shridhar@frodo.hserus.net>
0 siblings, 1 reply; 5+ messages in thread
From: Richard Huxton @ 2004-05-06 08:13 UTC (permalink / raw)
To: Christopher Kings-Lynne <chriskl@familyhealth.com.au>; +Cc: J. Andrew Rogers <jrogers@neopolitan.com>; Carlos Eduardo Smanioto <csmanioto@uol.com.br>; pgsql-performance
Christopher Kings-Lynne wrote:
>>> What's the case of bigger database PostgreSQL (so greate and amount of
>>> registers) that they know???
>
>
> Didn't someone say that RedSheriff had a 10TB postgres database or
> something?
From http://www.redsheriff.com/us/news/news_4_201.html
"According to the company, RedSheriff processes 10 billion records a
month and the total amount of data managed is more than 32TB. Griffin
said PostgreSQL has been in production for 12 months with not a single
database fault in that time “The stability of the database can not be
questioned. Needless to say, we are extremely happy."
I think it's safe to assume this is not on a spare Dell 600SC though.
--
Richard Huxton
Archonet Ltd
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [PERFORM] [OFF-TOPIC] - Known maximum size of the PostgreSQL
2004-05-05 21:11 ` Re: [OFF-TOPIC] - Known maximum size of the PostgreSQL J. Andrew Rogers <jrogers@neopolitan.com>
2004-05-06 01:48 ` Re: [OFF-TOPIC] - Known maximum size of the PostgreSQL Christopher Kings-Lynne <chriskl@familyhealth.com.au>
2004-05-06 08:13 ` Re: [OFF-TOPIC] - Known maximum size of the PostgreSQL Richard Huxton <dev@archonet.com>
@ 2004-05-06 08:43 ` Shridhar Daithankar <shridhar@frodo.hserus.net>
0 siblings, 0 replies; 5+ messages in thread
From: Shridhar Daithankar @ 2004-05-06 08:43 UTC (permalink / raw)
To: PostgreSQL Advocacy <pgsql-advocacy@postgresql.org>; +Cc: pgsql-performance
Richard Huxton wrote:
> Christopher Kings-Lynne wrote:
>
>>>> What's the case of bigger database PostgreSQL (so greate and amount of
>>>> registers) that they know???
>> Didn't someone say that RedSheriff had a 10TB postgres database or
>> something?
> From http://www.redsheriff.com/us/news/news_4_201.html
>
> "According to the company, RedSheriff processes 10 billion records a
> month and the total amount of data managed is more than 32TB. Griffin
> said PostgreSQL has been in production for 12 months with not a single
> database fault in that time “The stability of the database can not be
> questioned. Needless to say, we are extremely happy."
>
> I think it's safe to assume this is not on a spare Dell 600SC though.
>
I think we should have a case study for that. And publish it on our regular
news/press contacts(Can't imagine the flame war on /...Umm Yummy..:-)). It would
make a lot of noise and gain visibility for us.
Of course Red Sherrif need to co-operate and spell the details and/or moderate
what we write, but all in all, 32TB database is uber-cool..:-)
Shridhar
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [OFF-TOPIC] - Known maximum size of the PostgreSQL
@ 2004-05-05 21:23 ` scott.marlowe <scott.marlowe@ihs.com>
1 sibling, 0 replies; 5+ messages in thread
From: scott.marlowe @ 2004-05-05 21:23 UTC (permalink / raw)
To: Carlos Eduardo Smanioto <csmanioto@uol.com.br>; +Cc: pgsql-performance
On Sat, 5 Jun 2004, Carlos Eduardo Smanioto wrote:
> Hello all,
>
> What's the case of bigger database PostgreSQL (so greate and amount of
> registers) that they know???
http://www.postgresql.org/docs/faqs/FAQ.html#4.5
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2004-05-06 08:43 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-05-05 21:11 ` J. Andrew Rogers <jrogers@neopolitan.com>
2004-05-06 01:48 ` Christopher Kings-Lynne <chriskl@familyhealth.com.au>
2004-05-06 08:13 ` Richard Huxton <dev@archonet.com>
2004-05-06 08:43 ` Shridhar Daithankar <shridhar@frodo.hserus.net>
2004-05-05 21:23 ` scott.marlowe <scott.marlowe@ihs.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox