On Thu, Feb 8, 2024 at 12:42 AM sud <suds1434(at)gmail(dot)com> 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