3 ms·
Postgres should provide it, it just doesn't (yet). Usable native partitions didn't really arrive until v10 and v11 finally makes them production capable with ra
by manigandham 8y ago
Postgres should provide it, it just doesn't (yet). Usable native partitions didn't really arrive until v10 and v11 finally makes them production capable with range+hash, default partitions, moving rows when the partition key changes, pruning partitions in queries, etc.
Until then, extensions like Partman, Timescale, and Citus make up the functionality along with specializations for your use-case.