Logical Replicated Database Slow - Mailing list pgsql-admin

From Anjul Tyagi
Subject Logical Replicated Database Slow
Date
Msg-id em24a8b8ff-e852-42a1-9012-3ef630966368@iboss01108
Whole thread Raw
List pgsql-admin
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


pgsql-admin by date:

Previous
From: MichaelDBA
Date:
Subject: "strange" pg_rewind error
Next
From: Mahesh Wadekar
Date:
Subject: psql copy filename path wildcard