When setting up PostgreSQL on a local Macintosh computer for use with a local design instance of DSS, I've found that the default parameters for Postgres are set up to run on puny hardware, something like a Raspberry Pie. Even a 7-year-old Macbook Air has benefited by making some Postgres performance tuning changes.
Here is a link to an interesting presentation from the Postgres Conference called Configuring PostgreSQL for Faster Analytic Query Performance. This was given last week by Sebastian Dressler from Swarm64. Some very interesting findings around tuning and setting up PostgreSQL for data analytics.