Postgres Pro
Downloads
Home   >   mailing lists

Replication lag - Mailing list pgsql-admin

From Wasim Devale
Subject Replication lag
Date
Msg-id CAB5fag5ek2y21Op8emh+t_omMVxjXz9rVOv5HR_YzPNreYtgfA@mail.gmail.com
Whole thread Raw
Responses Re: Replication lag
Assunto: Replication lag
List pgsql-admin
Tree view
Hi everyone,

We have a setup of primary and replica database. We are using the replica as read only purpose. But the queries are long running queries that takes 30 minutes to complete.

Do we have any settings in place that will not show replication lag and the queries also executes on replica database without competition on WAL reply?

The settings:
Hot standby is off
And maximum streaming delay is set to -1

Thanks,
Wasim 

pgsql-admin by date:

Previous
From: Holger Jakobs
Date:
Subject: Re: How to increase the max query history stored
Next
From: Wasim Devale
Date:
Subject: Re: Replication lag