Hello Mark,
It depends on various variables. But, most probably it is related to disk IOPS limits of Azure.
-> What is your VM instance on Azure? (B8MS, D8a v4 etc.)
-> What is your disk size on Azure VM?
-> Which type of disk do you use on Azure? (Ultra Disk, Premium SSD, Standard SSD or Standard HDD)
-> What is your database size?
Combination of your answers to first 3 question determines your VMs IOPS, read and write limits. Then, you can compare them to your current installation.
Best regards.
Samed YILDIRIM
İyi çalışmalar.
Samed YILDIRIM
03.04.2020, 20:41, "Mark Steben" <mark.steben@xxxxxxxxxxxxxxxxx>:
Good afternoon,We currently run postgres 9.4 on a linux server in expedient. We have built a linux vm on azure and are currently running postgres 9.4 on that vm. We are now invoking streaming replicationexpedient >> azure with the schedule to cut over to the azure server late next week.I have run read queries on both and have seen that queries on the azure server run 3 to 4 times longer. The shared_buffers is the same on both - 8 GB - as is the work_mem of 64 MB. The linux box on Expedient has 64 GB memory available, while the Azure VM has 32 GB memory available.Everything else is the same. Do you have any insight as to what other configs to look out for to improve overall performance?Any insight appreciated. Thank you,--Mark Steben
Database Administrator
@utoRevenue | Autobase
CRM division of Dominion Dealer Solutions
95D Ashley Ave.
West Springfield, MA 01089
t: 413.327-3045
f: 413.383-9567www.fb.com/DominionDealerSolutions
www.twitter.com/DominionDealer
www.drivedominion.com
