On Thu, Feb 8, 2024 at 12:42 AM sud <suds1434@xxxxxxxxx> wrote:
...
The key transaction table is going to have ~450 Million transactions per day and the data querying/filtering will always happen based on the "transaction date" column.
...
Should we go for simple daily range partitioning on the transaction_date column?
This one gets my vote. That and some good indexes.
Cheers,
Greg
