3 ms·
some of my favorites: - transactional DDL: https://www.google.com/search?q=transactional+ddl+postgresql https://www.google.com/search?q=transactional+ddl+postg
by asah 8y ago
some of my favorites:
- transactional DDL: https://www.google.com/search?q=transactional+ddl+postgresql https://www.google.com/search?q=transactional+ddl+postgresql
- expression indexes: https://www.postgresql.org/docs/current/indexes-expressional.html https://www.postgresql.org/docs/current/indexes-expressional...
- partial indexes: https://www.postgresql.org/docs/current/indexes-partial.html https://www.postgresql.org/docs/current/indexes-partial.html
- Javascript UDFs (plv8): https://plv8.github.io https://plv8.github.io
- hyperloglog: https://github.com/citusdata/postgresql-hll/releases/tag/v2.10.2 https://github.com/citusdata/postgresql-hll/releases/tag/v2....
- tonyarkles 8y agoIt’s funny... I’ve been a Postgres user for a long time, and two years ago I had to work with MySQL and Oracle databases for a project with a client. I was absolutely horrified that they couldn’t do transactional DDL! I’d just been using that feature for so long that I assumed everything done in a transaction was atomic. That is such a huge feature!
- developer2 8y agoFYI, Postgresql also has DDL statements that are not transaction safe. The list is quite small compared to software like MySQL, but they still exist. I lost the list I had gathered from a handful of their developers in IRC once, so unfortunately I can't share. Just know that Postgres isn't 100% safe with DDL statements.