# The good stuff

* Aggregate functions
* Function indexes
* Partial indexes
* CTEs (WITH clauses)
* FDW (foreign data wrappers)
* Interesting types
  * Array
  * UUID
  * HStore
  * JSON/JSONB
* INSERT/UPDATE/DELETE...RETURNING
* Transactional DDL
* Replication
* Strict Typing
* Schemas
* Inheritance
* Partitioning
* Triggers
* MVCC
* Notify/Listen
* Multi-language support
* Stored procedures
* Functions as DEFAULT values
* COPY FROM, COPY TO
* Awesome documentation
* Fulltext search
* PostGIS
* Comments on schema elements (http://www.postgresql.org/docs/9.4/static/sql-comment.html)
* tablespaces

# Tips

* REPLACE not supported. Use UPDATE...ON NONEXISTENT INSERT (see 9.5 for new functionality)
* LIKE is case sensitive. ILIKE is not.
* information_schema
* Heroku, AWS RDS
* pgtune

# Users

* Opscode (Chef)
* Skype
* Instagram