On Thu, Feb 8, 2024 at 12:42 AM sud <suds1...@gmail.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