Обсуждение: Production Database requirement

Поиск
Список
Период
Сортировка

Production Database requirement

От
Azimuddin Mohammed
Дата:
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.

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


Thanks in Advance!


--

Regards,
Azim


Virus-free. www.avast.com

Re: Production Database requirement

От
Francis Santiago
Дата:


2018-01-04 14:47 GMT-03: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.

the minimum requirements depend of use the your bds, you can start by 50GB y,  memory 2 Gb, for example 

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

Yes, they can use VM'S 


Thanks in Advance!


--

Regards,
Azim


Virus-free. www.avast.com


Re: Production Database requirement

От
Francis Santiago
Дата:


2018-01-04 14:47 GMT-03: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.

the minimum requirements depend of use the your bds, you can start by 50GB y,  memory 2 Gb, for example 

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

Yes, they can use VM'S 


Thanks in Advance!


--

Regards,
Azim


Virus-free. www.avast.com


Re: Production Database requirement

От
Vincenzo Romano
Дата:
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


Re: Production Database requirement

От
Vincenzo Romano
Дата:
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