On 30.07.24 19:29, Kihaguru Gathura wrote: > Hi Claudio, > > Yes, I did run 'Explain Analyze' on the query to diagnose the > performance issues. Based on the analysis, I created indexes on the > relevant columns and ran a VACUUM on the tables. This resulted in an > improvement, reducing CPU utilization from 40% to 30%.
Out of curiosity. How many records (table rows) are you talking about? Maybe partitioning is the way to go, if you are dealing with huge amounts of data. Indexing a couple of billions of records still makes selecting expensive and you maybe want to partition things? -- Christian
