Postgres JOIN and Aggegration Speed UPs


We are planning to use Dremio (GKE) to connect to a Postgres database. Plan is to speed up long analytics queries by using data reflections (raw / aggregated). I want to understand the best practices and if they are documented somewhere. The queries that we plan to run

  1. have joins spanning across multiple tables.
  2. have few filter conditions on columns have very high cardinality.
  3. have a lot of aggregations like COUNT, MIN,MAX,AVG,SUM etc.
  4. make use of windows functions


@SAS080 Would you be able to go over this white paper and come back with questions? Happy to answer them