topic Re: Advantages to configure Qlik Sense to use a dedicated PostgreSQL database ? in Management & Governance

Advantages to configure Qlik Sense to use a dedicated PostgreSQL database ?

leonardo_lenzi — Thu, 08 Sep 2022 14:32:38 GMT

Hi,

We are planning the upgrade of our Qlik Sense Enterprise from version February 2021 to May 2022, and we would also like to upgrade the Repository Database from PostgreSQL 9.6 to PostgreSQL 12.5
Our Qlik Sense is deployed on a single node site.

So we are wondering if there are any advantages to move the Qlik Sense database to a standalone PostgreSQL server ?
Or maybe there are no significant advantages for a single node site ?

Thanks in advance for any feedback.
Leonardo

Re: Advantages to configure Qlik Sense to use a dedicated PostgreSQL database ?

Jay_Brown — Thu, 08 Sep 2022 15:24:37 GMT

Hello @leonardo_lenzi , thanks for reaching out.

You are correct; in a single-node environment there is no meaningful advantage for a standalone PostgreSQL server.

The requirements for PostgreSQL are somewhat minimal aside from edge cases in heavily utilized environments. Usually 4 cores / vCPU and 8GB of RAM is sufficient.

See the responses in a Hardware requirement discussion thread for reference:
https://community.qlik.com/t5/Deployment-Management/Hardware-requirements-for-a-PostgreSQL-server-that-is-only-used/td-p/1744047

If Qlik Sense is competing with PostgreSQL at the limit of CPU/RAM resources then you may want to consider a standalone deployment.

Re: Advantages to configure Qlik Sense to use a dedicated PostgreSQL database ?

Chip_Matejowsky — Thu, 08 Sep 2022 16:39:06 GMT

Hi @leonardo_lenzi,

In addition to Jay's excellent post see Qlik Support article & video Upgrading Qlik Sense Repository Database from PostgreSQL 9.6 to 12.5 - New tool available for upgrading the Postgres database.

Best Regards

Re: Advantages to configure Qlik Sense to use a dedicated PostgreSQL database ?

leonardo_lenzi — Mon, 12 Sep 2022 17:08:46 GMT

Hi @Jay_Brown

Thanks for your prompt reply and for the additional informations.

Leonardo