public inbox for [email protected]
help / color / mirror / Atom feedFrom: Marcus Vinicius Castro <[email protected]>
To: [email protected]
To: Pgsql-admin <[email protected]>
To: pgsql-admin <[email protected]>
Subject: Assunto: Replication lag
Date: Thu, 17 Apr 2025 22:13:38 +0000 (UTC)
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAB5fag5ek2y21Op8emh+t_omMVxjXz9rVOv5HR_YzPNreYtgfA@mail.gmail.com>
References: <CAB5fag5ek2y21Op8emh+t_omMVxjXz9rVOv5HR_YzPNreYtgfA@mail.gmail.com>
First you have to check the indexes and the query.
After that you can research on Google ways to increase the performance in database.
Best regards!
Yahoo Mail: Busque, organize e aumente sua produtividade
Em qui., 17 17e abr. 17e 2025 às 2:52, Wasim Devale<[email protected]> escreveu: 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 offAnd maximum streaming delay is set to -1
Thanks,Wasim
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: Assunto: Replication lag
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox