| 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.
| 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 |