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