postgres performance on azure

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 replication
expedient >> 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-9567

www.fb.com/DominionDealerSolutions
www.twitter.com/DominionDealer
 www.drivedominion.com






[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux