Re: postgres for production

2018-01-31 Thread Peter J. Holzer
On 2018-01-31 10:23:58 -0600, Azimuddin Mohammed wrote: > 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

Re: postgres for production

2018-01-31 Thread Azimuddin Mohammed
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 wrote: > Not really with only that i

Re: postgres for production

2018-01-31 Thread Scott Whitney
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

Re: postgres for production

2018-01-31 Thread Martin Moore
How much data do you have? That’s a fundamental thing to know. Martin. From: Azimuddin Mohammed Date: Wednesday, 31 January 2018 at 16:24 To: , Subject: postgres for production Hello, I have a question for postgres hardware requirement for production installation. My org want to