pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedMoving postgres 9.4 databases to new vm hosted datacenter
2+ messages / 2 participants
[nested] [flat]
* Moving postgres 9.4 databases to new vm hosted datacenter
@ 2019-02-21 12:42 Mark Steben <mark.steben@drivedominion.com>
0 siblings, 1 reply; 2+ messages in thread
From: Mark Steben @ 2019-02-21 12:42 UTC (permalink / raw)
To: 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;
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Moving postgres 9.4 databases to new vm hosted datacenter
@ 2019-02-21 14:41 Ron <ronljohnsonjr@gmail.com>
parent: Mark Steben <mark.steben@drivedominion.com>
0 siblings, 0 replies; 2+ messages in thread
From: Ron @ 2019-02-21 14:41 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
On 2/21/19 6:42 AM, Mark Steben wrote:
> 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?
WAL replay is single-threaded, so that won't work.
A few months ago, we migrated from physical to virtual (and upgraded from
8.4 to 9.6) without any performance drop by ensuring that the underlying ESX
host wasn't over-provisioned. Naturally, you'd also have to contract for
SSDs with Expedient.
--
Angular momentum makes the world go 'round.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2019-02-21 14:41 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2019-02-21 12:42 Moving postgres 9.4 databases to new vm hosted datacenter Mark Steben <mark.steben@drivedominion.com>
2019-02-21 14:41 ` Ron <ronljohnsonjr@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox