new material for "Postgres for MySQL users" presentation

From: Ondrej Ivanič <ondrej(dot)ivanic(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org general" <pgsql-general(at)postgresql(dot)org>
Subject: new material for "Postgres for MySQL users" presentation
Date: 2012-07-30 23:27:54
Message-ID: CAM6mieKW3vOPoZnLAjCXsHKFPcLy+mX43kfb21hMsyH4sQu=Lw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

Several years ago I gave this presentation to a bunch of PHP
developers in order to show then that something else is out there :).
Presentation was based on MySQL 4.1 and Postgres 8.2/8.3 (early 2008).
I would like to do it again and I'm looking for sources which can I
re-use (and credit back of course).

Presentation has the following structure:
- Installation (database server and required PHP modules)
- First look around (PGAdmin, psql)
- Postgres nomenclature and MySQL equivalents (database cluster,
schema, MVCC, fulltext)
- Let's create first database and users (psql, pg_hba, createdb,
createuser, ...)
- Basic performance tuning
- Cool things in Postgres (transactional DDL, PostGIS, custom types, ...)
- Annoying things (Slow count(*), (auto)vacuum/(auto)analyze)
- Replication and HA

I need to remove obsolete stuff and add new things like "extensions"
and "hstore" -- anything else worth mentioning? I would like to talk
more about replication and HA because Postgres implemented same set of
features like MySQL (but MySQL steps forward with master-master setup
(should I count Postgres-XC?)).

If you know about some good resources (presentations, blogs, ...)
which can I use please let me know!
Thanks!

--
Ondrej Ivanic
(ondrej(dot)ivanic(at)gmail(dot)com)

Browse pgsql-general by date

  From Date Subject
Next Message Steven Schlansker 2012-07-31 01:07:15 Postgres will not compile on Mac 10.8 with contrib/uuid-ossp
Previous Message Adrian Klaver 2012-07-30 22:52:26 Re: conversion from epoch