postgres for production

How much data do you have? That’s a fundamental thing to know.

Martin.

From: Azimuddin Mohammed <azimeiu@gmail.com>
Date: Wednesday, 31 January 2018 at 16:24
To: <pgsql-admin@postgresql.org>, <pgsql-general@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

Virus-free. www.avast.com

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 <azimeiu@gmail.com>
Sent: Wednesday, January 31, 2018 10:23 AM
To: pgsql-admin@postgresql.org; pgsql-general@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://ipmcdn.avast.com/images/icons/icon-envelope-tick-round-orange-animated-no-repeat-v1.gif]&lt;https://www.avast.com/sig-email?utm_medium=email&amp;utm_source=link&amp;utm_campaign=sig-email&amp;utm_content=webmail&amp;utm_term=icon&gt; Virus-free. www.avast.com<https://www.avast.com/sig-email?utm_medium=email&amp;utm_source=link&amp;utm_campaign=sig-email&amp;utm_content=webmail&amp;utm_term=link&gt;

Journyx, Inc.
7600 Burnet Road #300
Austin, TX 78757
www.journyx.com

p 512.834.8888
f 512-834-8858

Do you receive our promotional emails? Click here <http://journyx.com/communication-preferences&gt; or visit http://journyx.com/communication-preferences to unsubscribe.

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 <scott@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 <azimeiu@gmail.com>
*Sent:* Wednesday, January 31, 2018 10:23 AM
*To:* pgsql-admin@postgresql.org; pgsql-general@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&amp;utm_source=link&amp;utm_campaign=sig-email&amp;utm_content=webmail&amp;utm_term=icon&gt; Virus-free.
www.avast.com
<https://www.avast.com/sig-email?utm_medium=email&amp;utm_source=link&amp;utm_campaign=sig-email&amp;utm_content=webmail&amp;utm_term=link&gt;
<#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&amp;entry=gmail&amp;source=g&gt;
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&gt;or visit http://journyx.com/
communication-preferences to unsubscribe.

--

Regards,
Azim

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 write and 2 other DBs are read with write one. 

can someone suggest me is this a good configuration with respect to hardware ?

This is impossible to answer with the information you provided. Whether
64 GB are enough or not doesn't depend on the number of databases, but
on the size of the working set: Frequently used data should fit into RAM
with enough space to spare for sorting and maintenance operations.
Same for the number of cores: That mainly depends on the number of
concurrently active clients (although with PostgreSQL 10 you have
parallelized queries, so a single client might use more than one core).

hp

--
_ | Peter J. Holzer | we build much bigger, better disasters now
|_|_) | | because we have much more sophisticated
| | | hjp@hjp.at | management tools.
__/ | http://www.hjp.at/ | -- Ross Anderson <https://www.edge.org/&gt;