Re: Getting following error in using cursor to fetch the records from a large table in c language

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: M Tarkeshwar Rao <m(dot)tarkeshwar(dot)rao(at)ericsson(dot)com>, "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Getting following error in using cursor to fetch the records from a large table in c language
Date: 2019-10-31 06:57:43
Message-ID: 5bf3f04959a82a8733da61093720f929bba00947.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, 2019-10-31 at 05:18 +0000, M Tarkeshwar Rao wrote:
[queries get canceled on the standby]
> You are absolutely right. This is the issue with us.
> If we retry the query again. Will it be successful?

Sometimes :^/

> Can you please suggest how to configure hot_standby_feedback?

You set it to "on", then you get no query cancellation because of
VACUUM (at the price of potential bloat on the primary server).

Your query can still get canceled by conflichts with ACCESS EXCLUSIVE
locks that are taken by TRUNCATE, ALTER/DROP TABLE and similar
as well as autovacuum truncation.

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message M Tarkeshwar Rao 2019-10-31 07:15:01 RE: Getting following error in using cursor to fetch the records from a large table in c language
Previous Message rihad 2019-10-31 05:27:29 Re: Upgrade procedure