thanks for the reply scott. The reads are pretty quick, we will use pg for reading/storing metadata information only. not complex joins run, and the 4 dbs are of different size , each db around 200 GB max total
On Wed, Jan 31, 2018 at 10:28 AM, Scott Whitney <sc...@journyx.com> wrote: > Not really with only that information. There's a lot more to running any > database in a virtualized environment. > > > Additionally, 8 cores max? Well, how long does a read or a write take? Are > these complex SELECTs with multiple joins of millions of rows that return > in 30s or 1m? If so, do you have 10 people per minute trying to run them? > If so, life is not going to look good for you. > > > What size are the databases? 4 databases of equal size and equal use? Etc. > etc. > > > ------------------------------ > *From:* Azimuddin Mohammed <azim...@gmail.com> > *Sent:* Wednesday, January 31, 2018 10:23 AM > *To:* pgsql-ad...@postgresql.org; pgsql-gene...@postgresql.org > *Subject:* postgres for production > > Hello, > I have a question for postgres hardware requirement for production > installation. My org want to use Vms with only 8 cores max + 64Gb RAM max. > I have 4 database out of which 1 Db is write extensive 1 db is read > extensive and moderate write and 2 other DBs are read with write one. > > can someone suggest me is this a good configuration with respect to > hardware ? > > 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_3830895419825862837_x_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2> > > > Journyx, Inc. > 7600 Burnet Road #300 > <https://maps.google.com/?q=7600+Burnet+Road+%23300+%0D+Austin,+TX+78757&entry=gmail&source=g> > Austin, TX 78757 > www.journyx.com > > p 512.834.8888 <(512)%20834-8888> > f 512-834-8858 <(512)%20834-8858> > > Do you receive our promotional emails? Click here > <http://journyx.com/communication-preferences>or visit http://journyx.com/ > communication-preferences to unsubscribe. > -- Regards, Azim
