Thread: Examples of Large Datasets on Postgres?

Don,

> Can anyone point me in the right direction?  I realize I'm preaching among
> evangelists on this list, but maybe some of the folks here know someone who
> might be willing to talk?

A few off the top of my head:

Instagram had over 20TB of data in PostgreSQL at acquisition time per
their presentation; no doubt they have more, now.

Comptel's cell call tracking database for the EU had up to 75TB per city
for 20+ cities.

There's a marketing company in Australia which had over 200TB of data in
PostgreSQL -- I can't recall the name right now.

The Mormon Tabernacle's entire geneology database is in PostgreSQL; not
sure how big that is, but it covers over 200m individuals.

I don't know that anyone has petabytes on vanilla PostgreSQL; we don't
do well at that scale.  GreenPlum, Aster, etc. yes, but not mainstream
Postgres.  However, nobody has petabytes on mainstream Oracle either.

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com

Szymon,

> I think it should be promoted on the website. Many managers in huge
> companies don't know that and are afraid of using Postgres, I used to hear
> for years that "I'm afraid of switching to Postgres, as nobody uses that,
> and if they use it, there are just some toy projects".

Oh, no question.  It just requires a bunch of legwork by someone.

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com

> Thanks for the listing.  That gives me something to be able to discuss in
> class, at least.  I don't suppose you could help me get in contact with any
> of these companies?  Or maybe if I just drop a line on the general list,
> someone might take interest?

Hmmm.  I don't know that I can reach anyone at those organizations,
currently. One of the drawbacks of not having a formal sales
organization is that you don't have the ability to entice ongoing
testimonials via marketing discounts.

You have looked at the Quotes page also, yes?

Oh, and there's a great Case Study from the French Social Security
Administration:
http://www.wcm.bull.com/internet/pr/rend.jsp?DocId=594915&lang=en

(hey, why isn't that case study linked from the main site?)


--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com

2013/10/3 Don Parris <parrisdc@gmail.com>:
> Hi all,
>
> I believe this relates primarily to advocacy, so am posting here.  I would
> like to find examples of organizations running large datasets on PostgreSQL.
> The last survey on this (that I can find) is from 2004
> (http://www.postgresql.org/community/survey/26-how-large-is-your-postgresql-database/).
>
> I have also seen this example from 2008:
> http://it.toolbox.com/blogs/oracle-guide/worlds-largest-database-runs-on-postgres-24979

I can't provide details right now, but I'll be giving a talk at the
Japan PostgreSQL conference in November [1] about my employer's recent
Oracle -> PostgreSQL migration and will be making the material
available in English after that. The dataset is "only" a few TB
(albeit growing).

[1] http://www.postgresql.jp/events/jpug-pgcon2013/#A1

Regards

Ian Barwick