[tpm] toronto-pm Digest, Vol 66, Issue 9

[Carlo Costantini]

I would like to hear about:

why table inheritance is a good idea (best practices)
proper use of schemas (best practices)
upgrading from 8.x to 9.x and the benefits of 9.x
replication in 9.x
examples of foreign data wrappers
examples and benefits of using pl/perl vs pl/pgsql (is there a
performance penalty)
tips for helping n00bs ramp up

When is this talk going to be? October meeting or another date in the future?

On Sun, Sep 30, 2012 at 3:00 PM,  <toronto-pm-request at pm.org> wrote:
> Send toronto-pm mailing list submissions to
>         toronto-pm at pm.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
>         http://mail.pm.org/mailman/listinfo/toronto-pm
> or, via email, send a message with subject or body 'help' to
>         toronto-pm-request at pm.org
>
> You can reach the person managing the list at
>         toronto-pm-owner at pm.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of toronto-pm digest..."
>
>
> Today's Topics:
>
>    1. Re: RFC: Postgres talk coming up. Top ten questions please.
>       (William Muriithi)
>    2. Re: RFC:  Postgres talk coming up. Top ten questions please.
>       (James E Keenan)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Sat, 29 Sep 2012 16:08:46 -0400
> From: William Muriithi <william.muriithi at gmail.com>
> To: arocker at vex.net
> Cc: Toronto PerlMongers <tpm at to.pm.org>
> Subject: Re: [tpm] RFC: Postgres talk coming up. Top ten questions
>         please.
> Message-ID:
>         <CAE9rU+4kaEDXKJCWsZ6t6EPyGnV9d4CyFSWNu9RMiS3N2t4SLQ at mail.gmail.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
>>
>> Who's using PG? (Names that we would recognise.)
>
> Why is postgres not as widely used as MySQL despite being equally capable?
>
> Does postgres support master master setup for redundancy?
>
> How does postgres instrumentation infrastructure compare to those of oracle
> and MySQL?
>
> William
>>
>> Assuming that your problem requires a relational database, why Postgres vs
>>
>> a) MySQl
>> b) Oracle
>> c) SQLServer
>> d) Any other competitor I've forgotten?
>>
>> (Capabilities/strengths/weaknesses)?
>>
>> Which OS support PG?
>>
>> How would Perl fit in a PG environments? Invoking PG, querying, stored
>> procedures?
>>
>> Which is the definitive book on PG? What other documentation is available?
>>
>> Where do you get PG. How complex is it to install?
>>
>> _______________________________________________
>> toronto-pm mailing list
>> toronto-pm at pm.org
>> http://mail.pm.org/mailman/listinfo/toronto-pm
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <http://mail.pm.org/pipermail/toronto-pm/attachments/20120929/c2366cf2/attachment-0001.html>
>
> ------------------------------
>
> Message: 2
> Date: Sat, 29 Sep 2012 20:29:51 -0400
> From: James E Keenan <jkeen at verizon.net>
> To: toronto-pm at pm.org
> Subject: Re: [tpm] RFC:  Postgres talk coming up. Top ten questions
>         please.
> Message-ID: <5067927F.2070600 at verizon.net>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> On 9/29/12 1:37 PM, arocker at Vex.Net wrote:
>> Some random suggestions to provoke debate:
>>
>> Who's using PG? (Names that we would recognise.)
>>
>
> Jim Keenan!
>
> Which occurs because my somewhat recently new day job in NYC uses
> Postgres.  I have no prior experience with it, but colleagues in the
> Parrot project speak well of it.
>
>> Assuming that your problem requires a relational database, why Postgres vs
>>
>> a) MySQl
>> b) Oracle
>
> $$$
>
>> c) SQLServer
>
> $$$
>
>> d) Any other competitor I've forgotten?
>>
>> (Capabilities/strengths/weaknesses)?
>>
>> Which OS support PG?
>>
>
> I suspect the riposte would be:  Which doesn't?
>
>> How would Perl fit in a PG environments? Invoking PG, querying, stored
>> procedures?
>>
>
> DBI -- I finally have a chance to learn it in a practical way.
>
>> Which is the definitive book on PG? What other documentation is available?
>>
>
> I consult the online documentation every day.  It is considerably better
> than that of most OS projects.
>
>> Where do you get PG. How complex is it to install?
>>
>
> You download it :-)  But I'll let others speak to whether installation
> is complex or not.
>
>
> ------------------------------
>
> Subject: Digest Footer
>
> _______________________________________________
> toronto-pm mailing list
> toronto-pm at pm.org
> http://mail.pm.org/mailman/listinfo/toronto-pm
>
>
> ------------------------------
>
> End of toronto-pm Digest, Vol 66, Issue 9
> *****************************************