3 ms·
Last time I did partitioning by date in postgres (on postgres 9.?), multiple transaction_${date} tables is exactly what I got. They are exposed as a single 'tr
by greenshackle2 6y ago
Last time I did partitioning by date in postgres (on postgres 9.?), multiple transaction_${date} tables is exactly what I got.
They are exposed as a single 'transaction' table but they were really different physical tables.
My understanding is that partitioning is a more general term. Partitioning can be on one or multiple servers. Sharding is a type of partitioning that is always across multiple servers.