From: Anjul Tyagi <anjul@ibosstech-us.com>
To: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Logical Replicated Database Slow
Date: Mon, 04 May 2020 06:49:35 +0000
Message-ID: <em24a8b8ff-e852-42a1-9012-3ef630966368@iboss01108> (raw)
Hi All,
I have database that is logical replicated from production server for
reporting. I have noticed that server is quite slow as compare to
production database. i have validated configuration, its showing
correctly as per pgtune plug-in.
I have generated the explain plan and query is using proper index.
Do i have check the index bloat or need to do some re-indexing.
Can you please help me to find out the reason for slowness.
Regards,
Anjul TYAGI
ΓΌ Go Green
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: pgsql-admin@postgresql.org
Cc: anjul@ibosstech-us.com
Subject: Re: Logical Replicated Database Slow
In-Reply-To: <em24a8b8ff-e852-42a1-9012-3ef630966368@iboss01108>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox