PostgreSQL scaleability question

Started by Wang, Mary Yabout 21 years ago3 messagesgeneral
Jump to latest
#1Wang, Mary Y
mary.y.wang@boeing.com

Hi All,

I have been using PostgreSQL for my project repository, because it is
free and easy to use. My manager is trying to decide if he should use a
commercial database such as Oracle or PostgreSQL for a giant information
repository for the corporate. He asked me what is the scaleability on
PostgreSQL. I don't have the answer. So far, I have been very pleased
with PostgreSQL, but I'm only using it for my project.

Does anyone have any information on this? Has anyone done any
comparisons?

Many thanks in advance!

Mary Wang

#2Scott Marlowe
smarlowe@g2switchworks.com
In reply to: Wang, Mary Y (#1)
Re: PostgreSQL scaleability question

On Fri, 2005-02-18 at 15:51, Wang, Mary Y wrote:

Hi All,

I have been using PostgreSQL for my project repository, because it is
free and easy to use. My manager is trying to decide if he should use
a commercial database such as Oracle or PostgreSQL for a giant
information repository for the corporate. He asked me what is the
scaleability on PostgreSQL. I don't have the answer. So far, I have
been very pleased with PostgreSQL, but I'm only using it for my
project.

Does anyone have any information on this? Has anyone done any
comparisons?

The only way to really know if it can handle your load is to build a
simulation and test it.

While it may be reassuring to have a salesperson for Database brand Y
assure you it can handle your load, you don't really know until you test
it.

The biggest loads that are easy to find examples of in the press would
probably be those handled by afilias to host the .org domain. There are
bigger loads out there, that's just one of the easier ones to find.

For a list of a few known case studies, take a look here:

http://www.postgresql.org/about/casestudies/

#3Lonni J Friedman
netllama@gmail.com
In reply to: Wang, Mary Y (#1)
Re: PostgreSQL scaleability question

On Fri, 18 Feb 2005 13:51:00 -0800, Wang, Mary Y <mary.y.wang@boeing.com> wrote:

Hi All,

I have been using PostgreSQL for my project repository, because it is free
and easy to use. My manager is trying to decide if he should use a
commercial database such as Oracle or PostgreSQL for a giant information
repository for the corporate. He asked me what is the scaleability on
PostgreSQL. I don't have the answer. So far, I have been very pleased with
PostgreSQL, but I'm only using it for my project.

Does anyone have any information on this? Has anyone done any comparisons?

We'd kinda need to know exactly how you plan to use it before anyone
could comment on how postgresql would scale. What kind of usage
patterns do you anticipate?

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
L. Friedman netllama@gmail.com
LlamaLand http://netllama.linux-sxs.org