Hi,
I am using postgresql 12.7 on Ubunut as a datawarehouse, that is then
queried by QlikSense to produce business analytics.
One of my dataloaders, that runs multiple queries, sometimes takes about
3 hours to feed Qlik with the relevant records (about 10M records), but
sometimes goes crazy
en/declare-cursor-in-postgresql-or-how-to-reduce-memory-consumption/
to be interesting as an introduction to CURSOR with Postgresql.
I'll now work on this query to try to understand the problem.
Franck
Le jeudi 20 mai 2021 à 17:59 +0530, Ganesh Korde a écrit :
>
> Hi,
> On Tue, May 18, 202
, setting it to 1.0 (instead of the default 0.1) boosted the query
from more than 1 hour (sometime going crazy to several hours) to 15 minutes.
In general, I think 1.0 is the correct value when using Qlik, as loaders will
read all rows.
Franck
Le 20 mai 2021 21:33:25 GMT+02:00, "Franck Routier (