Re: Best options for new PG instance

From: Tim Cross <theophilusx(at)gmail(dot)com>
To: David Gauthier <davegauthierpg(at)gmail(dot)com>
Cc: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Best options for new PG instance
Date: 2018-03-05 21:10:07
Message-ID: 87muzm1b68.fsf@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


David Gauthier <davegauthierpg(at)gmail(dot)com> writes:

> Hi:
>
> I'm going to be requesting a PG DB instance (v9.6.7) from an IT dept in a
> large corp setting. I was wondering if anyone could comment on the
> pros/cons of getting this put on a virtual machine vs hard metal ? Locally
> mounted disk vs nfs ?
>

This is a hard question to answer as there are too many
variables. However, I would say that my experience has been that most
large organisations are pretty much using VMs for everything, so asking
for something on a 'bare metal' basis is likely to result in your
request needing special attention and justification. On the other hand,
if you make a standard request, it will likely be fulfilled more
rapidly. Sys admins are likely to be resistant to a bare metal setup if
their infrastructure is based around VMs due tot he additional work and
maintenance overheads.

All our databases are running on VMs. Some of them are storing fairly
large amounts of data (i.e. one application stores large amounts of
weather data - adding 650 million records a day with a consolidation
after every 100 days. Currently, the DB is using about 6Tb, so not huge,
but not insignificant). Disk storage is via SAN.

Getting the right performance will require tweaking of memory, cpus
etc. The good news is that adding additional memory and CPUs is
relatively trivial.

For our situation, VMs have been fine and there has been some advantages
with SAN storage infrastructure, such as fast snapshots for backups
etc. In general, I usually find it best to work with the system admins
and follow their recommendations. Provide them with details of your
performance requirements and where you feel resource demands may peak
and let them propose what they feel would be best suited given whatever
infrastructure they have.

Tim

--
Tim Cross

In response to

Browse pgsql-general by date

  From Date Subject
Next Message rob stone 2018-03-05 23:36:27 Re: JDBC4 and setting statement_timeout: responds "is not yet implemented"
Previous Message Andres Freund 2018-03-05 21:01:48 Re: PQConsumeinput stuck on recv