<div>Hello Mark,</div><div> </div><div>It depends on various variables. But, most probably it is related to disk IOPS limits of Azure.</div><div>-> What is your VM instance on Azure? (B8MS, D8a v4 etc.)</div><div>-> What is your disk size on Azure VM?</div><div>-> Which type of disk do you use on Azure? (Ultra Disk, Premium SSD, Standard SSD or Standard HDD)</div><div>-> What is your database size?</div><div> </div><div>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.</div><div> </div><div>Best regards.</div><div>Samed YILDIRIM</div><div><br /></div><div><br /></div><div>İyi çalışmalar.</div><div>Samed YILDIRIM</div><div><br /></div><div><br /></div><div><br /></div><div>03.04.2020, 20:41, "Mark Steben" <mark(dot)steben(at)drivedominion(dot)com>:</div><blockquote><div dir="ltr">Good afternoon,<div>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 replication</div><div>expedient >> azure with the schedule to cut over to the azure server late next week.</div><div><br /></div><div>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.</div><div><br /></div><div>Everything else is the same. Do you have any insight as to what other configs to look out for to improve overall performance? </div><div><br /></div><div>Any insight appreciated. Thank you,<br clear="all" /><div><br /></div>-- <br /><div class="e1d38c8ade1c674c7b90783c258010cfb30df4607e362d32a5e14865f204c094gmail_signature" dir="ltr"><div><font color="#888888"><span style="color:rgb( 51 , 51 , 51 );font-family:'calibri';font-size:11pt"><b>Mark Steben</b></span><span style="font-family:'calibri';font-size:11pt"> </span><br /> Database Administrator<span style="color:rgb( 51 , 51 , 51 );font-family:'century gothic';font-size:8pt"></span><span style="font-family:'century gothic';font-size:8pt"><br /><a href="http://www.autorevenue.com/" style="color:rgb( 79 , 129 , 189 );font-size:8pt;font-weight:bold;text-decoration:none">@utoRevenue</a> </span><span style="color:rgb( 79 , 129 , 189 );font-family:'century gothic';font-size:10pt">|</span><span style="font-family:'century gothic';font-size:8pt"> <a href="http://www.autobase.net/" style="color:rgb( 79 , 129 , 189 );font-size:8pt;font-weight:bold;text-decoration:none">Autobase</a> </span><span style="color:rgb( 79 , 129 , 189 );font-family:'century gothic';font-size:10pt"></span><span style="font-family:'century gothic';font-size:8pt"> <br /> <span style="color:rgb( 79 , 129 , 189 );font-size:8pt;font-weight:bold;text-decoration:none">CRM division of Dominion Dealer Solutions</span> <br /></span><span style="color:gray;font-family:'century gothic';font-size:8pt">95D Ashley Ave.<br />West Springfield, MA 01089</span><span style="font-family:'century gothic';font-size:8pt"> <br />
</span><span style="color:gray;font-family:'century gothic';font-size:8pt">t: 413.<span class="177d5a4333ac019606de889e143743a1wmi-callto">327-3045</span></span><span style="font-family:'century gothic';font-size:8pt"> <br /></span><span style="color:gray;font-family:'century gothic';font-size:8pt">f: 413.<span class="177d5a4333ac019606de889e143743a1wmi-callto">383-9567</span></span><span style="font-family:'century gothic';font-size:8pt"> </span></font></div><p><font color="#888888"><span style="font-family:'century gothic';font-size:8pt"><a href="http://www.fb.com/DominionDealerSolutions">www.fb.com/DominionDealerSolutions</a><br /><a href="http://www.twitter.com/DominionDealer">www.twitter.com/DominionDealer</a><br /></span><span style="color:gray;font-family:'century gothic';font-size:8pt"> <a href="http://www.autorevenue.com/">www.drivedominion.com</a><br /><br /><a href="http://autobasedigital.net/marketing/DD12_sig.jpg"></a><br /><br /></span></font><br /><font color="#888888"><span style="color:gray;font-family:'century gothic';font-size:8pt"><br /></span></font></p></div></div></div>
</blockquote>
