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-13 04:22:00
Message-ID: 1463113320738-5903415.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
Thank you for the explanation.
The slave queries are mostly reporting queries,which sometimes would take
30+ running time due to complex joins and criteria. We haven't tried running
these queries on master before splitting, and it is possible that there will
be heavy updates and deletes on master on some tables some times. Now we
have to decide between these two parameters as which one to use. Can you
give any suggestion?

--
View this message in context: http://postgresql.nabble.com/Update-or-Delete-causes-canceling-of-long-running-slave-queries-tp5903250p5903415.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 JingYuan Chen 2016-05-13 06:44:31 Share my experience and Thank you !
Previous Message Sridhar N Bamandlapally 2016-05-13 03:15:46 Re: [GENERAL] NULL concatenation