On Thu, Feb 8, 2024 at 12:42 AM sud <[email protected]> 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
