Horton

Thread

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

    J. Andrew Rogers <jrogers@neopolitan.com> — 2004-05-05T21:11:29Z

    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

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

    scott.marlowe <scott.marlowe@ihs.com> — 2004-05-05T21:23:03Z

    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

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

    Christopher Kings-Lynne <chriskl@familyhealth.com.au> — 2004-05-06T01:48:30Z

    >>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

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

    Richard Huxton <dev@archonet.com> — 2004-05-06T08:13:10Z

    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

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

    Shridhar Daithankar <shridhar@frodo.hserus.net> — 2004-05-06T08:43:25Z

    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

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

    Don Vaillancourt <donv@webimpact.com> — 2004-05-06T13:47:08Z

    Here's a question a little off-topic.

What would a 32TB database hardware configuration look like.  I'm assuming 
200GB hard-drives which would total 160 of them.  Double that if you mirror 
them.

Am I correct?

At 04:13 AM 06/05/2004, you 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.
>
>--
>   Richard Huxton
>   Archonet Ltd
>
>---------------------------(end of broadcast)---------------------------
>TIP 7: don't forget to increase your free space map settings

Don Vaillancourt
Director of Software Development

WEB IMPACT INC.
416-815-2000 ext. 245
email: donv@webimpact.com
web: http://www.webimpact.com



This email message is intended only for the addressee(s)
and contains information that may be confidential and/or
copyright.  If you are not the intended recipient please
notify the sender by reply email and immediately delete
this email. Use, disclosure or reproduction of this email
by anyone other than the intended recipient(s) is strictly
prohibited. No representation is made that this email or
any attachments are free of viruses. Virus scanning is
recommended and is the responsibility of the recipient.

  7. Re: [PERFORM] [OFF-TOPIC] - Known maximum size of

    Gavin Sherry <swm@linuxworld.com.au> — 2004-05-06T22:29:11Z

    On Thu, 6 May 2004, Shridhar Daithankar wrote:

> 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..:-)

I've tried contacting them. They will not return my phone calls or emails.

Gavin

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

    Gaetano Mendola <mendola@bigfoot.com> — 2004-05-07T23:35:44Z

    Don Vaillancourt wrote:

> 
> Here's a question a little off-topic.
> 
> What would a 32TB database hardware configuration look like.  I'm 
> assuming 200GB hard-drives which would total 160 of them.  Double that 
> if you mirror them.
> 
> Am I correct?

Why do you have to mirror them ? Usually a SAN make data redundancy
using a RAID 4 or 5, this depend if you need read performances or
write performances, in the case of Red Sherif I guess that guys are
using RAID 50 ( 0 + 5 ) sets so what you "waste" is a disk for each
set.



Regards
Gaetano Mendola

  9. [OFF-TOPIC] - Known maximum size of the PostgreSQL Database

    Carlos Eduardo Smanioto <csmanioto@uol.com.br> — 2004-06-05T18:55:32Z

    Hello all,

What's the case of bigger database PostgreSQL (so greate and amount of
registers) that they know???

Thanks,
Carlos Eduardo Smanioto