Skip to content

Instantly share code, notes, and snippets.

@cobusc

cobusc/why_postgresql.md

Last active August 29, 2015 14:23
Show Gist options
  • Save cobusc/44ab84595c98855b922e to your computer and use it in GitHub Desktop.
Save cobusc/44ab84595c98855b922e to your computer and use it in GitHub Desktop.
Download ZIP
Why Postgresql
Raw
why_postgresql.md

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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment