Re: Production Database requirement - Mailing list pgsql-admin

From Vincenzo Romano
Subject Re: Production Database requirement
Date
Msg-id CAHjZ2x6jq8HRYZASoTFwAqfdLRt5NcQW8CYYwS=CmViDt5q7cQ@mail.gmail.com
Whole thread Raw
In response to Production Database requirement  (Azimuddin Mohammed <azimeiu@gmail.com>)
List pgsql-admin
2018-01-04 18:47 GMT+01:00 Azimuddin Mohammed <azimeiu@gmail.com>:
> Hello All,
> Can anyone please let me know
>
> 1. What is the hardware and software  requirement for postgressql to be
> installed in production. We are planning to use postgres for hadoop backend,
> to store user access info, metadata etc. So, it will not be high transaction
> db, but we might see lost of reads to this db.

Your question makes little sense without any details about the data
and the application architecture.
Please elaborate more.
You'd elaborate more on these points in order to get some meaningful advise.

> 2. Can we use Vm's to run the Db? Is it recommended ?

There's nothing against virtualization apart the computing and I/O
limits it can pose.
In general, real hardware can provide for better performances.

> Thanks in Advance!
>
>
> --
>
> Regards,
> Azim
>
>
> Virus-free. www.avast.com



-- 
Vincenzo Romano - NotOrAnd.IT
Information Technologies
--
NON QVIETIS MARIBVS NAVTA PERITVS


pgsql-admin by date:

Previous
From: Francis Santiago
Date:
Subject: Re: Production Database requirement
Next
From: Bruce Momjian
Date:
Subject: Re: pg_upgradecluster 9.5 -> 9.6 fails "Error: could not get clusterlocales" on Ubuntu 17.04