Moving postgres 9.4 databases to new vm hosted datacenter

From: Mark Steben <mark(dot)steben(at)drivedominion(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Moving postgres 9.4 databases to new vm hosted datacenter
Date: 2019-02-21 12:42:27
Message-ID: CADyzmyzvch1jqj--2YqY1KzHa-RBBh2gmagQgzzdrQ-x11KDGQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Good morning,
We are presently planning to move our 9.4 production databases from our
datacenter in Norfolk where they have been running on solid state hardware
to a datacenter run by Expedient where they will run on pre-defined vms.
Our manager of development has expressed concern that there may be a
decline in performance - we had a similar decline several years ago when we
attempted to switch to vms.
My question is: is there a facility we can install on the vm where we can
simulate what we run on production now to approximate the load that we
currently run? Perhaps a read / replay of the postgres logs?

--
*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 Ron 2019-02-21 14:41:51 Re: Moving postgres 9.4 databases to new vm hosted datacenter
Previous Message Ron 2019-02-21 00:38:20 Precompressed data in TOASTed columns (was Re: Regarding postgreSQL performance on DRAM)