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.ivanic@xxxxxxxxx) -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
