Re: Start of the Seattle Postgres Users Group (Seapug)

Thanks Lloyd, here are a couple that jumped out at me:

Over Normalization from a developers point of view -
http://pugs.postgresql.org/node/1618
extreme database makeover -
http://www.chesnok.com/daily/2008/02/27/extreme-database-makeover-rt-meeting-recap/
materialized views - http://pugs.postgresql.org/node/620

Doug

On Wed, Feb 17, 2010 at 2:58 PM, Albin, Lloyd P <lalbin(at)scharp(dot)org> wrote:
> Doug,
>
> Send me a list of which specific talks you are interested in, that pdxpug held, and I can contact the speakers about those specifici talks.
>
> Lloyd
>
> -----Original Message-----
> From: Doug Cole [mailto:doug(at)estately(dot)com]
> Sent: Wednesday, February 17, 2010 2:56 PM
> To: Robert Bernier
> Cc: Albin, Lloyd P; seapug(at)postgresql(dot)org
> Subject: Re: [seapug] Start of the Seattle Postgres Users Group (Seapug)
>
> Personally the talks I'd be most interested in hearing are related to database design and performance.  As a programmer learning to be a dba as I go the postgresql problems I run into most at work involve keeping query times reasonable as the size of our database grows, maybe not postgresql specific, but talks about topics like ranging from the basic considerations when designing new database schemas, to when and how to approach de-normalization of your data, partitioning, sharding, materialized views,etc.  Looking through pdxpug's notes on past meetings it looks like they've had quite a few talks in this genre.  If you are interested and willing to talk about one of these subjects Robert I think that would be awesome, otherwise maybe we could convince some of pdxpug's previous speakers to come up here and give their talks again.
>
> Robert from your list below, I'd be most interested in learning more about connection pooling with PGPool, thanks for offering to talk.
> Doug
>
> On Sun, Feb 14, 2010 at 1:29 PM, Robert Bernier <robert(at)pg-live(dot)info> wrote:
>> Hi Lloyd,
>>
>> As per our conversation at last week's first ever SEAPUG, you asked what kind of talks I could offer for future meetings.
>>
>> I've got teaching material for virtually any and all basic PostgreSQL activities.  Although these days it's kinda hard to say what exactly constitute 'basic' since a lot of knowledge is required by the DBA before he even begins his foray into PostgreSQL.
>>
>> I'm pretty much open to any suggestions as to what you'd like me to offer in the way of presentation. Maybe we can get some input from the others who are currently subscribed to this mail list as to what they'd like to see.
>>
>> At the top of my head here's a list of topics that might pique your interest:
>> Installing PostgreSQL
>>        Unix/Linux/BSD Installation (Binary and Source)
>>        Windows Installation
>>        Configuration
>>
>> Server Startup and Shutdown
>>        Command Line Invocation
>>        Explicitly Installing and Running a Service
>>        Shutting Down the Server
>>        The Use of Signals in a UNIX environment
>>
>> Privileges, and Security
>>        About Database Roles
>>                Attributes
>>                Privileges
>>                Membership
>>
>>        Authentication techniques (editing the pg_hba.conf file)
>>                Unix socket domains
>>                How to use IDENT
>>                How to use PAM
>>                How to use KERBEROS
>>
>>        Encrypted sessions
>>                port forwarding with SSH
>>                Using SSL
>>                Data Encryption
>>
>> Backup, Logging, and Recovery
>>        Command line utilties
>>        Point In Time Recovery
>>
>> Supporting projects
>>        SLONY
>>        PGPOOL
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> --
>> Robert Bernier
>>   PostgreSQL Business Intelligence Analyst
>>   robert(at)pg-live(dot)info
>>
>>
>> --
>> Sent via seapug mailing list (seapug(at)postgresql(dot)org) To make changes
>> to your subscription:
>> http://www.postgresql.org/mailpref/seapug
>>
>