Re: Update or Delete causes canceling of long running slave queries

From: Viswanath <M(dot)Viswanath16(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Update or Delete causes canceling of long running slave queries
Date: 2016-05-12 18:14:39
Message-ID: 1463076879434-5903344.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Jeff,
Yes I am turning off autovacuum for experimental purpose only. I was
curious to know what is causing the queries to be killed when the autovacuum
is not running. I guess it had to be the pruning of HOT update chains like
you have mentioned.
Also I have already tried changing the parameters hot_standby_feedback and
vacuum_defer_cleanup_age, it works fine, but if HOT update is the problem
then changing these setting will hinder it right? If so then is it safe to
use these parameters? Or will there be any notable problems or performance
issues? This pruning of HOT update could be the case for update only or
delete queries too?

--
View this message in context: http://postgresql.nabble.com/Update-or-Delete-causes-canceling-of-long-running-slave-queries-tp5903250p5903344.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Klaus P. Pieper - ibeq GmbH 2016-05-12 18:22:05 ON CONFLICT DO for UPDATE statements
Previous Message db042190 2016-05-12 18:08:50 Re: downloaded 32 bit pg 9.1 but driver isnt seeing some rows