If your application is write intensive LSM is better than Btree. But you'd rarely need it. We mostly have write intensive counters. We just write to redis firs

If your application is write intensive LSM is better than Btree. But you'd rarely need it. We mostly have write intensive counters. We just write to redis first then aggregate and write to postgres. This reduces number of writes we need in postgres a lot