Production Database requirement
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
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=icon>
Virus-free.
www.avast.com
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=link>
<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
2018-01-04 14:47 GMT-03:00 Azimuddin Mohammed <azimeiu@gmail.com>:
Hello All,
Can anyone please let me know1. 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
Show quoted text
Thanks in Advance!
--
Regards,
Azim<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=icon> Virus-free.
www.avast.com
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=link>
<#m_2540529285869011783_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
2018-01-04 18:47 GMT+01:00 Azimuddin Mohammed <azimeiu@gmail.com>:
Hello All,
Can anyone please let me know1. 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,
AzimVirus-free. www.avast.com
--
Vincenzo Romano - NotOrAnd.IT
Information Technologies
--
NON QVIETIS MARIBVS NAVTA PERITVS
Salam Mohammed,
Am DATE hackte Azimuddin Mohammed in die Tasten:
Hello All,
Can anyone please let me know1. 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.
It sound a only a little bit more what I have a s /etc/passwd, /etc/shadow,
/etc/groups and /etc/gshadow replacement...
I have exactly this too and it rund quiert well on a MiniITX with 1000MHz
and 1 GByte of memory which is 60% unused. The Debian GNU/Linux 7.11
installation together with the postgresql database using less then
5 GByte... Lets say, the whole thing would run an a 20 GByte HDD.
I manage currently 23.000 users with it...
And no, I do not use LDAP.
My webservices authenticate directly with the database server which is
hostet at a friendly ISP in Estonia.
2. Can we use Vm's to run the Db? Is it recommended ?
Yes of course.
Thanks in Advance!
------------------------------------------------------------------------
--
Michelle Konzack
00372-54541400