Successfully passed the 2nd master class "Using PostgreSQL in web applications"

The first PostgreSQL masterclass was held as part of PHPConf 2004
In the current - there were a lot of questions about the correct tuning PostgreSQL
and the use of interesting solutions when designing a database (scaling tables to different servers and much more).

Also interesting were searches for a missing index :-)
Friendly and direct atmosphere helped
all participants find practical solutions to the challenges they face.
Many of the participants pointed to the weak distribution of PostgreSQL among domestic hosts.
From the findings on the master class - the LiveCD is already with a ready course,
that in the future will allow for remote training, the participant must
will download (get) the disc and handout to get started with the master class.
It is worth noting the professionalism of the leading:
Nikolay Samokhvalov - architect and developer of the PostgreSQL DBMS
Ivan Zolotukhina - leading developer and administrator of PostgreSQL
http://postgresmen.ru/


')
Master Class Program

• A brief history of PostgreSQL. Current version. Opportunities.
  Installation in conjunction with Apache / PHP. Initial setting.
  Start scripts for various OS. Psql console,
  GUI application pgAdmin III, web management interface phpPgAdmin.
  Regression tests, benchmarks. HelloWorld.
  PostgreSQL device: MVCC, transaction, VACUUM.
  Cluster concept. Scheme. System catalogs.
  Basic configuration settings.
  Methods to improve performance: configuring postgresql.conf, using indexes, changing SQL queries, persistent connection, load balancing.
  Base status monitoring, statistics.
  Types of indexes. Log analysis with pgFouine.
  Variety of procedural languages ​​(PL / pgSQL, PL / Perl, plPHP). Triggers and functions. Rule, view. The mechanism of inheritance. Prepared transactions. Two-phase commit.
  Additional features: contrib modules. GiST-based modules intarray, hstore, ltree, pg_trgm. Full-text search (tsearch2) and its capabilities.
  
  
  Wishing to participate in the next. master classes - subscribe to the newsletter