SEO

#1 (**permalink**) 04-09-2008, 05:58 AM

Hello,

My company is looking at two very large DB vendors to bear most of data
burden of our company; however I'd like to propose PostgresQL to handle
some of the tasks, specifically a large number read-only search DBs.
Postgres already has the win in terms of features and it's now down to
risk.

Many of the other folks at the company feel an open-source DB is more
risky because it is less well tested compared to commercial
counterparts. I'm looking for examples of large installations of
Postgres with huge data sets, high traffic volumes, high update rates,
etc, particularly large, recognizable names. I know you guys get this
question a lot, but can anyone share experiences with using Postgres in
large settings with huge query rates, replication, etc? Any stories you
guys can share (in public or private) would be greatly appreciated.
Thanks in advance!

Logan Bowers

#2 (**permalink**) 04-09-2008, 06:00 AM

Take a look at http://www.postgresql.org/about/casestudies/ for some
examples of use. Looking through the pgsql-advocacy mailing list might
provide some more cases as well. Of the top of my head, I believe
there's at least one national banking system running on PostgreSQL, as
well as all of the .org TLD.

BTW, how do you define 'huge data sets' and 'huge query rates'? Some
people have pretty skewed ideas about what 'huge' is.

I maintain
http://stats.distributed.net, which has a ~12G database on the backend;
many would think that's huge; I think it's at best small-medium.

As for support, as others have mentioned there are commercial companies
(such as mine) that will sell support. Plus, the support from the
community is generally top-notch as well.

On Thu, Sep 15, 2005 at 11:25:49PM -0400, Logan Bowers wrote:
> Hello,
>
>
>
> My company is looking at two very large DB vendors to bear most of data
> burden of our company; however I'd like to propose PostgresQL to handle
> some of the tasks, specifically a large number read-only search DBs.
> Postgres already has the win in terms of features and it's now down to
> risk.
>
>
>
> Many of the other folks at the company feel an open-source DB is more
> risky because it is less well tested compared to commercial
> counterparts. I'm looking for examples of large installations of
> Postgres with huge data sets, high traffic volumes, high update rates,
> etc, particularly large, recognizable names. I know you guys get this
> question a lot, but can anyone share experiences with using Postgres in
> large settings with huge query rates, replication, etc? Any stories you
> guys can share (in public or private) would be greatly appreciated.
> Thanks in advance!
>
>
>
> Logan Bowers
>

--
Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

#3 (**permalink**) 04-09-2008, 06:00 AM

On 9/16/05, Logan Bowers <logan@zillow.com> wrote:
>
> I'm looking for examples of large installations of Postgres with huge data
> sets, high traffic volumes, high update rates, etc, particularly large,
> recognizable names.
>

can you tell us/me what do you mean by huge? i heard people saying that a
table with 100000 rows is very big, and i have heard people saying that 12gb
with about 100milion rows is a small database.

depesz

#4 (**permalink**) 04-09-2008, 06:01 AM

On Sep 15, 2005, at 11:25 PM, Logan Bowers wrote:

> Many of the other folks at the company feel an open-source DB is
> more risky because it is less well tested compared to commercial
> counterparts. I’m looking for examples of large installations of
> Postgres with huge data sets, high traffic volumes, high update
> rates, etc, particularly large, recognizable names. I know you
> guys get this question a lot, but can anyone share experiences with
> using Postgres in large settings with huge query rates,
> replication, etc? Any stories you guys can share (in public or
> private) would be greatly appreciated. Thanks in advance!

Every so often on the slony (Postgres replication) list, a fellow
from Skype pops up. I suspect they use postgres under high volume,
huge dataset situation...

Also, do a "whois slony.info" or any *.info domain and you hit a
replicated postgres database. The entire .info (and now .org) domain
registries are stored on postgres.

Vivek Khera, Ph.D.
+1-301-869-4449 x806

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

BIG installations of PostgresQL?