| 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: | Whole Thread | Raw Message | 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)
| 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 |