Re: Postgres cursor taking 2 hrs to update the table

2019-12-24 Thread Adrian Klaver
On 12/24/19 2:32 AM, M Tarkeshwar Rao wrote: Hi, I have the 10 application processes(each process having 12 threads and each of have updating 8 million rows in the shared memory) which are reading the data from single postgres database. We are using database cursors in C++ to fetch the data a

Postgres cursor taking 2 hrs to update the table

2019-12-24 Thread M Tarkeshwar Rao
Hi, I have the 10 application processes(each process having 12 threads and each of have updating 8 million rows in the shared memory) which are reading the data from single postgres database. We are using database cursors in C++ to fetch the data and updating the shared memory. There is the tim