Re: Postgres cursor taking 2 hrs to update the table

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 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?/

By providing more information:

1) Postgres version?

2) OS and version?

3) Where the client and server are relative to each other?

4) Any relevant information from the Postgres log?

You might also look at:

https://www.postgresql.org/docs/11/auto-explain.html

>
> Regards
>
> Tarkeshwar
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com