Search Postgresql Archives

Postgres cursor taking 2 hrs to update the table

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 timer attached, where all the processor threads going to fetch the data.

 

The issue is that sometimes it is fetching all the data in few seconds and sometimes it is taking 2 hrs.

 

What could be the issue. Can you please guide me to resolve the issue?

 

Regards

Tarkeshwar


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux