Setting up PostgreSQL on local Macintosh

Options
tgb417
tgb417 Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Neuron 2020, Neuron, Registered, Dataiku Frontrunner Awards 2021 Finalist, Neuron 2021, Neuron 2022, Frontrunner 2022 Finalist, Frontrunner 2022 Winner, Dataiku Frontrunner Awards 2021 Participant, Frontrunner 2022 Participant, Neuron 2023 Posts: 1,595 Neuron

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.

I find a good place to start is with one of the online tuning tools. To do this I've been using https://pgtune.leopard.in.ua/#/

Postgres Tuning.jpg

This has given me some reasonable parameters and noticeable performance improvement across the DSS platform.

Of course, every situation is different, backup, go with care.

Has anyone else been doing Postgres tuning as part of one of your DSS instances. What things are you seeing when it comes to getting Postgres to work with DSS.

Answers

  • tgb417
    tgb417 Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Neuron 2020, Neuron, Registered, Dataiku Frontrunner Awards 2021 Finalist, Neuron 2021, Neuron 2022, Frontrunner 2022 Finalist, Frontrunner 2022 Winner, Dataiku Frontrunner Awards 2021 Participant, Frontrunner 2022 Participant, Neuron 2023 Posts: 1,595 Neuron
    Options

    All,

    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.

Setup Info
    Tags
      Help me…