Logical Replicated Database Slow

Поиск
Список
Период
Сортировка
От Anjul Tyagi
Тема Logical Replicated Database Slow
Дата
Msg-id em24a8b8ff-e852-42a1-9012-3ef630966368@iboss01108
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: MichaelDBA
Дата:
Сообщение: "strange" pg_rewind error
Следующее
От: Mahesh Wadekar
Дата:
Сообщение: psql copy filename path wildcard