Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jVUvD-0002BA-8q for pgsql-admin@arkaria.postgresql.org; Mon, 04 May 2020 06:49:47 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jVUvB-0007SW-Vg for pgsql-admin@arkaria.postgresql.org; Mon, 04 May 2020 06:49:45 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jVUvB-0007SO-7b for pgsql-admin@lists.postgresql.org; Mon, 04 May 2020 06:49:45 +0000 Received: from cloudearth.serversfarm.com ([216.244.65.90]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jVUv8-000589-FT for pgsql-admin@postgresql.org; Mon, 04 May 2020 06:49:44 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=ibosstech-us.com; s=x; h=Content-Type:Mime-Version:Reply-To:Message-Id:Date :Subject:To:From:Sender:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:Resent-Date:Resent-From:Resent-Sender:Resent-To:Resent-Cc :Resent-Message-ID:In-Reply-To:References:List-Id:List-Help:List-Unsubscribe: List-Subscribe:List-Post:List-Owner:List-Archive; bh=LG8g0G2V1g7SAq4bxEHd/wVRCzflE8HAvAIQKbW+uQw=; b=I+D6pjVT2V7+s9H7GZOMQO0YS4 TbzsXOcC79CRdBG+MVkLTL80jmNiHPeGd4Zh5Jx9Pg6NzVudRK9VC5QKcfHK21naOO0itTWatXBH9 CtnLojFzmDyBtAtT0LzF4jMW0plOI0cjUBd0lEK3LyGLywkWZ7qCpPzdjf+WIaLKofP/dJiSziqGe JMxzIq4CJ5v2VxzxYwoe6twYSe9BG5tTAjM8rpqGRJ9sGWCVOb3KFM6n8uTQCPG4ZuiC/FBQhvzpe sBDAEPkGfFD4RnRReM94ES2W9sZdeNzXABqQVsMCcM7LAfMUl/+Rbs2EvVozj2bl+Ih/dcBOdbThV nDK+aonQ==; Received: from [111.93.60.54] (helo=[192.168.20.146]) by cloudearth.serversfarm.com with esmtpsa (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.93.0.4) (envelope-from ) id 1jVUv6-00EgUp-SM for pgsql-admin@postgresql.org; Mon, 04 May 2020 02:49:41 -0400 From: "Anjul Tyagi" To: pgsql-admin Subject: Logical Replicated Database Slow Date: Mon, 04 May 2020 06:49:35 +0000 Message-Id: Reply-To: "Anjul Tyagi" User-Agent: eM_Client/7.2.37929.0 Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="------=_MB9346AFEE-0D85-41E8-BEF2-F84AA14F0B7C" X-Authenticated-Id: anjul@ibosstech-us.com List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --------=_MB9346AFEE-0D85-41E8-BEF2-F84AA14F0B7C Content-Type: text/plain; format=flowed; charset=utf-8 Content-Transfer-Encoding: quoted-printable Hi All, I have database that is logical replicated from production server for=20 reporting. I have noticed that server is quite slow as compare to=20 production database. i have validated configuration, its showing=20 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 =C3=BC Go Green --------=_MB9346AFEE-0D85-41E8-BEF2-F84AA14F0B7C Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable

Hi All,

I have database that is logic= al replicated from production server for reporting. I have noticed that ser= ver is quite slow as compare to production database. i have validated confi= guration, its showing correctly as per pgtune plug-in.=C2=A0

I have generated the explain plan and query is using proper in= dex.=C2=A0

Do i have check the index bloat or ne= ed to do some re-indexing.

Can you please help m= e to find out the reason for slowness.=C2=A0

=C2=A0

Regards,

Anjul TYAGI

=C2=A0

=C3=BC<= /b>=C2=A0Go=C2= =A0Green

--------=_MB9346AFEE-0D85-41E8-BEF2-F84AA14F0B7C--