Re: [pgsql-advocacy] Deployment Case Study Presentations

One of the most useful things I've found regarding MySQL is the deployment
presentations that various sites have put together. Sites like Flickr,
LiveJournal, Mixi, Wikipedia and others have put together presentations
detailing their load, environments and configurations. Here is a list of the
presentations I have found:

http://www.dev411.com/blog/2006/10/05/mysql-deployment-presentations

I think presentations like these make people more confident about choosing
and scaling with MySQL. Is there anything like these for high traffic/load
sites for PostgreSQL?

--
John Wang
http://www.dev411.com/blog/

John Wang wrote:

> http://www.dev411.com/blog/2006/10/05/mysql-deployment-presentations
>
> I think presentations like these make people more confident about
> choosing and scaling with MySQL. Is there anything like these for high
> traffic/load sites for PostgreSQL?

http://images.omniti.net/omniti.com/~jesus/misc/BBPostgres.pdf

regards,
Lukas

On Fri, Oct 06, 2006 at 08:34:17AM +0200, Lukas Kahwe Smith wrote:
> John Wang wrote:
>
> >http://www.dev411.com/blog/2006/10/05/mysql-deployment-presentations
> >
> >I think presentations like these make people more confident about
> >choosing and scaling with MySQL. Is there anything like these for high
> >traffic/load sites for PostgreSQL?
>
> http://images.omniti.net/omniti.com/~jesus/misc/BBPostgres.pdf

That should be added to http://www.postgresql.org/about/casestudies/
--
Jim Nasby jim(at)nasby(dot)net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)

On 10/10/06, Jim C. Nasby <jim(at)nasby(dot)net> wrote:
>
> On Fri, Oct 06, 2006 at 08:34:17AM +0200, Lukas Kahwe Smith wrote:
> > John Wang wrote:
> >
> > >http://www.dev411.com/blog/2006/10/05/mysql-deployment-presentations
> > >
> > >I think presentations like these make people more confident about
> > >choosing and scaling with MySQL. Is there anything like these for high
> > >traffic/load sites for PostgreSQL?
> >
> > http://images.omniti.net/omniti.com/~jesus/misc/BBPostgres.pdf
>
> That should be added to http://www.postgresql.org/about/casestudies/
>

Thanks Lukas and Jim. The OmniTI presentation is great and along the lines
that I'm looking for, presentations that are geared towards a technical
audience working on deploying and adminstering the database. The documents
at /about/casestudies seem more marketing oriented and less useful for
someone who has to roll up his/her sleeves. I purposely did not list
marketing case study material for MySQL because it's not as interesting for
me at the moment. I've added a link to the OmniTI presentation but left off
the marketing oriented brochures and white papers.

On a related topic, does anyone know of any high traffic Web 2.0 sites using
PostgreSQL (with or without presentations)? It seems like most of the high
traffc Web 2.0 sites use MySQL. It would be good to know if PostgreSQL is
deployed in situations with similar load profiles.

--
John Wang
http://www.dev411.com/blog/

johncwang(at)gmail(dot)com ("John Wang") writes:
> Thanks Lukas and Jim. The OmniTI presentation is great and along the
> lines that I'm looking for, presentations that are geared towards a
> technical audience working on deploying and adminstering the
> database.

Speaking of presentations, does anyone have one on pl/Perl? Or
something that has a chunk of material on pl/Perl? I presented for
the local LUG last night <http://gtalug.org/wiki/Meetings:2006-10> on
"What's new with 8.2?", and was asked if I could present something to
the local PerlMongers <http://to.pm.org/>.

If there's some material to borrow concerning:
a) Pl/perl - the new generation
b) The state of DBI
c) Evil libraries that will cause your apps to suck [dbrow comes to mind;
it has a habit of leaving transactions open, <IDLE> in transaction...]
that could be purty handy.

I should see about uploading my presentation somewhere on the Techdocs
site so that people might be able to mine it, too...
--
select 'cbbrowne' || '@' || 'acm.org';
http://linuxdatabases.info/info/multiplexor.html
QT adds to a Linux distribution a level of licencing complexity that
nullifies one of the major virtues of Linux: no licencing complexity.
-- <jedi(at)dementia(dot)mishnet>

On Wed, Oct 11, 2006 at 03:54:30PM -0400, Chris Browne wrote:
> johncwang(at)gmail(dot)com ("John Wang") writes:
> > Thanks Lukas and Jim. The OmniTI presentation is great and along
> > the lines that I'm looking for, presentations that are geared
> > towards a technical audience working on deploying and adminstering
> > the database.
>
> Speaking of presentations, does anyone have one on pl/Perl? Or
> something that has a chunk of material on pl/Perl?

I've got some slides from a PL/Perl talk I gave at FISL 7.0
<http://fetter.org/Perl_and_PostgreSQL.pdf>

The slides illustrate one cute thing you can do with PL/Perl that
would be challenging any other way :)

Cheers,
Dave.
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
phone: +1 415 235 3778 AIM: dfetter666
Skype: davidfetter

Remember to vote!

david(at)fetter(dot)org (David Fetter) writes:
> On Wed, Oct 11, 2006 at 03:54:30PM -0400, Chris Browne wrote:
>> johncwang(at)gmail(dot)com ("John Wang") writes:
>> > Thanks Lukas and Jim. The OmniTI presentation is great and along
>> > the lines that I'm looking for, presentations that are geared
>> > towards a technical audience working on deploying and adminstering
>> > the database.
>>
>> Speaking of presentations, does anyone have one on pl/Perl? Or
>> something that has a chunk of material on pl/Perl?
>
> I've got some slides from a PL/Perl talk I gave at FISL 7.0
> <http://fetter.org/Perl_and_PostgreSQL.pdf>
>
> The slides illustrate one cute thing you can do with PL/Perl that
> would be challenging any other way :)

Pretty neat, albeit brief. [And definitely done using Keynote...]

Something that strikes me as really useful would be to point to some
Perl DB access libraries as being either highly recommended or not
based on stuff like whether they hold transactions open. That's not a
pl/Perl thing, but it falls into what PerlMongers ought to be
interested in.
--
let name="cbbrowne" and tld="acm.org" in name ^ "@" ^ tld;;
http://cbbrowne.com/info/x.html
Editing is a rewording activity.
-- Alan J. Perlis
[And EMACS a rewording editor. Ed.]

On Wed, Oct 11, 2006 at 05:46:59PM -0400, Chris Browne wrote:
> david(at)fetter(dot)org (David Fetter) writes:
> > On Wed, Oct 11, 2006 at 03:54:30PM -0400, Chris Browne wrote:
> >> johncwang(at)gmail(dot)com ("John Wang") writes:
> >> > Thanks Lukas and Jim. The OmniTI presentation is great and
> >> > along the lines that I'm looking for, presentations that are
> >> > geared towards a technical audience working on deploying and
> >> > adminstering the database.
> >>
> >> Speaking of presentations, does anyone have one on pl/Perl? Or
> >> something that has a chunk of material on pl/Perl?
> >
> > I've got some slides from a PL/Perl talk I gave at FISL 7.0
> > <http://fetter.org/Perl_and_PostgreSQL.pdf>
> >
> > The slides illustrate one cute thing you can do with PL/Perl that
> > would be challenging any other way :)
>
> Pretty neat, albeit brief.

Good talks are like good dresses: short enough to be interesting, long
enough to cover the subject.

> [And definitely done using Keynote...]

And proud of it. :)

> Something that strikes me as really useful would be to point to some
> Perl DB access libraries as being either highly recommended or not
> based on stuff like whether they hold transactions open. That's not
> a pl/Perl thing, but it falls into what PerlMongers ought to be
> interested in.

I'll be shoving DBI-Link 2.0beta1 out the door tomorrow or Friday. :)
Explaining how it works to a newcomer audience would take a couple of
hours, tho. Some of the other slides on
<http://fetter.org/resume.html> also at least touch on PL/Perl.

Cheers,
D
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
phone: +1 415 235 3778 AIM: dfetter666
Skype: davidfetter

Remember to vote!

On Wednesday 11 October 2006 12:30, John Wang wrote:
> On 10/10/06, Jim C. Nasby <jim(at)nasby(dot)net> wrote:
> > On Fri, Oct 06, 2006 at 08:34:17AM +0200, Lukas Kahwe Smith wrote:
> > > John Wang wrote:
> > > >http://www.dev411.com/blog/2006/10/05/mysql-deployment-presentations
> > > >
> > > >I think presentations like these make people more confident about
> > > >choosing and scaling with MySQL. Is there anything like these for high
> > > >traffic/load sites for PostgreSQL?
> > >
> > > http://images.omniti.net/omniti.com/~jesus/misc/BBPostgres.pdf
> >
> > That should be added to http://www.postgresql.org/about/casestudies/
>
> Thanks Lukas and Jim. The OmniTI presentation is great and along the lines
> that I'm looking for, presentations that are geared towards a technical
> audience working on deploying and adminstering the database. The documents
> at /about/casestudies seem more marketing oriented and less useful for
> someone who has to roll up his/her sleeves. I purposely did not list
> marketing case study material for MySQL because it's not as interesting for
> me at the moment. I've added a link to the OmniTI presentation but left off
> the marketing oriented brochures and white papers.
>

Sun has recently released a case study that was done with OmniTI
(http://www.sun.com/emrkt/srsc/postgresql.html) . Folks have mentioned
putting OmniTI on the website before; as this perticular case study focus's
on both solaris and postgresql, I am thinking of adding OmniTI under the
featured users list with a pointer to the pdf, as it fits in more with the
types of articles we have featured on that list. Any objections?

--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL

Robert Treat wrote:
> Sun has recently released a case study that was done with OmniTI
> (http://www.sun.com/emrkt/srsc/postgresql.html) . Folks have mentioned
> putting OmniTI on the website before; as this perticular case study focus's
> on both solaris and postgresql, I am thinking of adding OmniTI under the
> featured users list with a pointer to the pdf, as it fits in more with the
> types of articles we have featured on that list. Any objections?

Please add them -- I have seen the Omni IT name around a lot recently.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

On Tue, Feb 20, 2007 at 10:10:04PM -0500, Robert Treat wrote:
> On Wednesday 11 October 2006 12:30, John Wang wrote:
> > On 10/10/06, Jim C. Nasby <jim(at)nasby(dot)net> wrote:
> > > On Fri, Oct 06, 2006 at 08:34:17AM +0200, Lukas Kahwe Smith wrote:
> > > > John Wang wrote:
> > > > >http://www.dev411.com/blog/2006/10/05/mysql-deployment-presentations
> > > > >
> > > > >I think presentations like these make people more confident
> > > > >about choosing and scaling with MySQL. Is there anything like
> > > > >these for high traffic/load sites for PostgreSQL?
> > > >
> > > > http://images.omniti.net/omniti.com/~jesus/misc/BBPostgres.pdf
> > >
> > > That should be added to
> > > http://www.postgresql.org/about/casestudies/
> >
> > Thanks Lukas and Jim. The OmniTI presentation is great and along
> > the lines that I'm looking for, presentations that are geared
> > towards a technical audience working on deploying and adminstering
> > the database. The documents at /about/casestudies seem more
> > marketing oriented and less useful for someone who has to roll up
> > his/her sleeves. I purposely did not list marketing case study
> > material for MySQL because it's not as interesting for me at the
> > moment. I've added a link to the OmniTI presentation but left off
> > the marketing oriented brochures and white papers.
> >
>
> Sun has recently released a case study that was done with OmniTI
> (http://www.sun.com/emrkt/srsc/postgresql.html) . Folks have
> mentioned putting OmniTI on the website before; as this perticular
> case study focus's on both solaris and postgresql, I am thinking of
> adding OmniTI under the featured users list with a pointer to the
> pdf, as it fits in more with the types of articles we have featured
> on that list. Any objections?

Would it have killed you guys to mention DBI-Link in there? ;)

Cheers,
D
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
phone: +1 415 235 3778 AIM: dfetter666
Skype: davidfetter

Remember to vote!

>> Sun has recently released a case study that was done with OmniTI
>> (http://www.sun.com/emrkt/srsc/postgresql.html) . Folks have
>> mentioned putting OmniTI on the website before; as this perticular
>> case study focus's on both solaris and postgresql, I am thinking of
>> adding OmniTI under the featured users list with a pointer to the
>> pdf, as it fits in more with the types of articles we have featured
>> on that list. Any objections?
>
> Would it have killed you guys to mention DBI-Link in there? ;)

Of course it would ;)

Joshua D. Drake

>
> Cheers,
> D

--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/