Обсуждение: Postgres References

Hello,

I work for Bull Information Systems in Phoenix.

We have this year converted a very large site in Europe to use Postgres.     They execute 1 Billion SQL statements per day....

Now they have a new CIO.  The new CIO is questioning about PostgreSQL References : he fears of being alone running such a large production with PostgreSQL

I know this is the week for PGWest, and I wish I were there....so I don't know if this message is an inconvenience or  perhaps an opportunity to ask the question to others.

In any case thanks for your thoughts.

Ken Rosensteel
Bull Information Systems
(602) 862-4532

On ons, 2010-11-03 at 07:57 -0700, Ken.Rosensteel@Bull.com wrote:
> Now they have a new CIO.  The new CIO is questioning about PostgreSQL
> References : he fears of being alone running such a large production with
> PostgreSQL

This should get you started:
http://en.wikipedia.org/wiki/Postgresql#Prominent_users

I don't se NTT on that list.

On Mon, Nov 8, 2010 at 10:47 AM, Peter Eisentraut <peter_e@gmx.net> wrote:
> On ons, 2010-11-03 at 07:57 -0700, Ken.Rosensteel@Bull.com wrote:
>> Now they have a new CIO.  The new CIO is questioning about PostgreSQL
>> References : he fears of being alone running such a large production with
>> PostgreSQL
>
> This should get you started:
> http://en.wikipedia.org/wiki/Postgresql#Prominent_users
>
>
>
> --
> Sent via pgsql-advocacy mailing list (pgsql-advocacy@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-advocacy
>



--
Regards,
Richard Broersma Jr.

Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug

Richard,

NTT may not be on that list because they are an EnterpriseDB customer and they are using Postgres Plus Advanced Server not the community PostgreSQL.

Cheers,
Sean





--
Sean Crowley
Director of Marketing
EnterpriseDB Corporation
The Enterprise Postgres Company
sean.crowley@enterprisedb.com
w - 978-589-5729
c - 617-584-5630
Website: www.enterprisedb.com

Follow us:
EnterpriseDB Blog: http://blogs.enterprisedb.com/
Twitter: http://www.twitter.com/enterprisedb
LinkedIn: http://www.linkedin.com/companies/14958
Facebook: http://www.facebook.com/#!/pages/EnterpriseDB/11117810845?ref=ts


This e-mail message (and any attachment) is intended for the use of the individual or entity to whom it is addressed. This message contains information from EnterpriseDB Corporation that may be privileged, confidential, or exempt from disclosure under applicable law. If you are not the intended recipient or authorized to receive this for the intended recipient, any use, dissemination, distribution, retention, archiving, or copying of this communication is strictly prohibited. If you have received this e-mail in error, please notify the sender immediately by reply e-mail and delete this message.

<Ken.Rosensteel@Bull.com> wrote:

> We have this year converted a very large site in Europe to use
> Postgres.  They execute 1 Billion SQL statements per day....
>
> Now they have a new CIO.  The new CIO is questioning about
> PostgreSQL References : he fears of being alone running such a
> large production with PostgreSQL

The Wisconsin Court System is not a prominent enough user to make
the Wikipedia list mentioned in another post, but each day we
execute about 80 million database transactions against about 100
databases distributed around the state.  Many of those transactions
involve using a cursor to loop through large result sets; so, while
I don't have hard numbers on the number of SQL statements executed
each day, it would probably be somewhere in the neighborhood of a
billion.

-Kevin

On Mon, Nov 8, 2010 at 11:05 AM, Sean Crowley
<sean.crowley@enterprisedb.com> wrote:
> Richard,
>
> NTT may not be on that list because they are an EnterpriseDB customer and
> they are using Postgres Plus Advanced Server not the community PostgreSQL.

I'm pretty sure they use both. There are divisions of NTT that use it,
and aren't customers of ours.


--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

--
Sean Crowley
Director of Marketing
EnterpriseDB Corporation
The Enterprise Postgres Company
sean.crowley@enterprisedb.com
w - 978-589-5729
c - 617-584-5630
Website: www.enterprisedb.com

Follow us:
EnterpriseDB Blog: http://blogs.enterprisedb.com/
Twitter: http://www.twitter.com/enterprisedb
LinkedIn: http://www.linkedin.com/companies/14958
Facebook: http://www.facebook.com/#!/pages/EnterpriseDB/11117810845?ref=ts


This e-mail message (and any attachment) is intended for the use of the individual or entity to whom it is addressed. This message contains information from EnterpriseDB Corporation that may be privileged, confidential, or exempt from disclosure under applicable law. If you are not the intended recipient or authorized to receive this for the intended recipient, any use, dissemination, distribution, retention, archiving, or copying of this communication is strictly prohibited. If you have received this e-mail in error, please notify the sender immediately by reply e-mail and delete this message.

On Mon, Nov 8, 2010 at 11:05 AM, Sean Crowley
<sean.crowley@enterprisedb.com> wrote:

> NTT may not be on that list because they are an EnterpriseDB customer and
> they are using Postgres Plus Advanced Server not the community PostgreSQL.

That makes sense.  But should Yahoo be even be listed then, since
their fork of Postgresql is even more drastic than EnterpriseDB's?
Also,  NTT seems to be heavily invested in the community version since
they're participating in the development of some of its nicer
features.


--
Regards,
Richard Broersma Jr.

Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug

Excerpts from Kevin Grittner's message of lun nov 08 16:11:52 -0300 2010:

> The Wisconsin Court System is not a prominent enough user to make
> the Wikipedia list mentioned in another post, but each day we
> execute about 80 million database transactions against about 100
> databases distributed around the state.  Many of those transactions
> involve using a cursor to loop through large result sets; so, while
> I don't have hard numbers on the number of SQL statements executed
> each day, it would probably be somewhere in the neighborhood of a
> billion.

I think the large number of servers makes your systems a very
interesting use case.  It says to prospective organizations "you don't
need to spend hundreds of thousands in server licenses, because you can
deploy as many servers as you want".  This is a powerful message, even
if each individual server is not all that impressive.

--
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

On mån, 2010-11-08 at 10:51 -0800, Richard Broersma wrote:
> I don't se NTT on that list.

Well, it's Wikipedia, not PostgreSQL-case-study-pedia.

There is a list of case studies on the PostgreSQL web site, but that
doesn't exactly look like alleviating the "fears of being alone"
concern.

Forks are really a whole different matter.

Returning to the original question; Caixa (sp?) Bank is a great
example. Iirc, they're the biggest bank in Brazil, and run their ATM
network on PG.

On 11/8/10, Richard Broersma <richard.broersma@gmail.com> wrote:
> On Mon, Nov 8, 2010 at 11:05 AM, Sean Crowley
> <sean.crowley@enterprisedb.com> wrote:
>
>> NTT may not be on that list because they are an EnterpriseDB customer and
>> they are using Postgres Plus Advanced Server not the community PostgreSQL.
>
> That makes sense.  But should Yahoo be even be listed then, since
> their fork of Postgresql is even more drastic than EnterpriseDB's?
> Also,  NTT seems to be heavily invested in the community version since
> they're participating in the development of some of its nicer
> features.
>
>
> --
> Regards,
> Richard Broersma Jr.
>
> Visit the Los Angeles PostgreSQL Users Group (LAPUG)
> http://pugs.postgresql.org/lapug
>
> --
> Sent via pgsql-advocacy mailing list (pgsql-advocacy@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-advocacy
>


--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

> There is a list of case studies on the PostgreSQL web site, but that
> doesn't exactly look like alleviating the "fears of being alone"
> concern.

Yeah, we've needed someone to take over the "Reference users" portion of
the site for some time.  I've been waiting for us to move to Django to
make it easier to do that as an app, so that adding a new reference user
isn't a matter of finicky HTML.

Case studies are another matter, and I think we should stop pretending
to have them.

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

On mån, 2010-11-08 at 13:55 -0800, Josh Berkus wrote:
> > There is a list of case studies on the PostgreSQL web site, but that
> > doesn't exactly look like alleviating the "fears of being alone"
> > concern.
>
> Yeah, we've needed someone to take over the "Reference users" portion of
> the site for some time.  I've been waiting for us to move to Django to
> make it easier to do that as an app, so that adding a new reference user
> isn't a matter of finicky HTML.
>
> Case studies are another matter, and I think we should stop pretending
> to have them.

I think what would actually work best is if we had a Wikipedia-like
listing in our wiki.  Meaning everyone could add information, the main
requirements being notability and cited sources.

Hello list,


NTT (it's a group of companies) uses both EDB Postgres Plus products and the community PostgreSQL. For the EDB's, EDB
peopleknow our utilization, and I will not mention that here. For the community PostgreSQL, I know we are using
versionsof it at about 150 sites. Unfortunately, for many of them I do not know how it is used in detail. Also, I
cannotsay words involved in our customers' matter. I may say something for the technical stuff, however, if you want
(andof course if I know). 

Thank you,

-hitoshi



> On Mon, Nov 8, 2010 at 11:05 AM, Sean Crowley
> <sean.crowley@enterprisedb.com> wrote:
>
>
>> NTT may not be on that list because they are an EnterpriseDB customer and
>> they are using Postgres Plus Advanced Server not the community PostgreSQL.
>>
>
> That makes sense.  But should Yahoo be even be listed then, since
> their fork of Postgresql is even more drastic than EnterpriseDB's?
> Also,  NTT seems to be heavily invested in the community version since
> they're participating in the development of some of its nicer
> features.
>
>
>


--
Hitoshi HEMMI
NTT Open Source Software Center
hemmi.hitoshi@oss.ntt.co.jp
Tel:(03)5860-5115
Fax:(03)5463-5490

Kevin,

Our customer is

The Caisse Nationale d'Allocations Familiales (CNAF) - the family branch of the French social security system, which provided some €69 billion of benefits to 11 million claimants in 2009.

The sales team asks if it is possible for the CIO of CNAF to meet with a large U.S. user of Postgres.


Would appreciate your thoughts...

Best Regards,

Ken Rosensteel
Bull Information Systems
Phoenix, Arizona
(602) 862-4532
http://www.linkedin.com/in/krosensteel

"Kevin Grittner" <Kevin.Grittner@wicourts.gov> 11/08/2010 12:12 PM

To <Ken.Rosensteel@Bull.com>, <pgsql-advocacy@postgresql.org> cc Subject Re: [pgsql-advocacy] Postgres References

<Ken.Rosensteel@Bull.com> wrote:

> We have this year converted a very large site in Europe to use
> Postgres.  They execute 1 Billion SQL statements per day....
>
> Now they have a new CIO.  The new CIO is questioning about
> PostgreSQL References : he fears of being alone running such a
> large production with PostgreSQL

The Wisconsin Court System is not a prominent enough user to make
the Wikipedia list mentioned in another post, but each day we
execute about 80 million database transactions against about 100
databases distributed around the state.  Many of those transactions
involve using a cursor to loop through large result sets; so, while
I don't have hard numbers on the number of SQL statements executed
each day, it would probably be somewhere in the neighborhood of a
billion.

-Kevin