3 ms·
Very neat list. If I had the know-how I would do 2 things to Postgres to make some of these items more useful: - Foreign key support for inherited tables (i.e.
by jarym 8y ago
Very neat list. If I had the know-how I would do 2 things to Postgres to make some of these items more useful:
- Foreign key support for inherited tables (i.e. a foreign key referencing a table with inheritance, the other way round works just fine). Table inheritance is super useful but lack of full foreign key support means we have to give up on some integrity (or replace them with hand-written constraints).
- Bloom indexes on arrays and bigint (int8) types - would make it feasible to (almost) 'index all things' when working mostly with numeric data.
- i_have_to_speak 8y agoForeign keys for partitions is coming in Postgres 12: https://www.depesz.com/2019/04/24/waiting-for-postgresql-12-support-foreign-keys-that-reference-partitioned-tables/ https://www.depesz.com/2019/04/24/waiting-for-postgresql-12-...