PostgreSQL common problems and solutions

PostgreSQL is the world’s most advanced SQL open source database. It contains comparable enterprise class features such as full ACID compliance and Multi-Version Concurrency Control for supporting high concurrent loads. And it supports standards such as ANSI SQL and SQL/MED (including foreign data wrappers for Oracle, MySQL, MongoDB and many others) and yet is highly extensible with support for over 12 procedural languages, GIN and GIST Indexes, Spatial data support, and multiple NoSQL like features for document (JSON) or key-value based applications.

Continue reading