Re: postgres for production

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(at)hjp(dot)at | management tools.
__/ | http://www.hjp.at/ | -- Ross Anderson <https://www.edge.org/>