On Sun, Feb 18, 2024 at 10:32 PM Darryl Green <darryl.green@xxxxxxxxx> wrote:
I am struggling to see the overall benefit of partitioning here. How many total rows and inserts per second, anyway?
1) Is my attempt to improve performance of insert AND (as the number of sources goes up, as it has) querying which is invariably by id but it is easy to include "and src = "" in the majority of usage (the other common case is to query across all sources, asking for a set is unusual) a reasonable approach?
I am struggling to see the overall benefit of partitioning here. How many total rows and inserts per second, anyway?
If the app already knows the src (as evidenced by adding in "and src = "" and you query by id, why would you partition by src?
It may help us all to take a step back and describe the problem here with specific timing numbers (for a slow INSERT rate maybe?) rather than trying to force one particular solution to work.
Cheers,
Greg
