Re: Production Database requirement

From: Vincenzo Romano <vincenzo(dot)romano(at)notorand(dot)it>
To: Azimuddin Mohammed <azimeiu(at)gmail(dot)com>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org, PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Production Database requirement
Date: 2018-01-04 18:22:41
Message-ID: CAHjZ2x6jq8HRYZASoTFwAqfdLRt5NcQW8CYYwS=CmViDt5q7cQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

2018-01-04 18:47 GMT+01:00 Azimuddin Mohammed <azimeiu(at)gmail(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Bruce Momjian 2018-01-04 18:40:06 Re: pg_upgradecluster 9.5 -> 9.6 fails "Error: could not get cluster locales" on Ubuntu 17.04
Previous Message Francis Santiago 2018-01-04 17:58:48 Re: Production Database requirement

Browse pgsql-general by date

  From Date Subject
Next Message Tiffany Thang 2018-01-04 18:58:31 Re: Replication questions - read-only and temporary read/write slaves
Previous Message Francis Santiago 2018-01-04 17:58:48 Re: Production Database requirement