postgres performance on azure

From: Mark Steben <mark(dot)steben(at)drivedominion(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: postgres performance on azure
Date: 2020-04-03 17:41:21
Message-ID: CADyzmyy7YWSy1BcdggiZuRYafHH6q=VohX=NOMdi_m8nTP4VFA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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 <http://www.autorevenue.com/> | Autobase
<http://www.autobase.net/>
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 <http://www.autorevenue.com/>

<http://autobasedigital.net/marketing/DD12_sig.jpg>

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Samed YILDIRIM 2020-04-03 18:01:12 Re: postgres performance on azure
Previous Message Ken Benson 2020-04-03 16:36:37 RE: How to get off the email list?