Re: Calculate hardware requirements

Thank you for the detailed reply. I understand my question is generic. But
just thought if I can get some good place to start. I will look into the
suggestions you made.

On Thu, Jun 4, 2020 at 4:02 PM Fabio Pardi <f(dot)pardi(at)portavita(dot)eu> wrote:

> Hi,
>
> in my opinion your question is too generic to get an accurate answer. To
> educate yourself reading Postgres docs or some good books would be in my
> opinion the best way to give an answer yourself to your own question. Then
> you can still post to the ML on some specific setting (postgres performance
> ML is the best place).
>
> Much of the requirements depends on the expected load on the database and
> what kind of usage you will do, such as OLTP or DWH/BI. Also the database
> size is important to fit in the picture.
>
> As rule of thumb, you want all your installations to be identical in terms
> of hardware specs. CPU should be able to serve your queries and your
> clients, so you must have enough cores to serve the expected number of
> connections without degrading performances.
>
> About RAM, the more the better, but if you have enough to fit your db (or
> the part you use of your db) in RAM, you will probably avoid many of your
> problems about disks performances.
>
> Do not forget disks, RAID controllers, networking, SLA, SLO, HA, DR..
>
> OT: I would use newer Postgres than 9.6 if I were you, unless you have
> good reasons to use 9.6.
>
>
> regards,
>
> fabio pardi
>
>
>
>
> On 04/06/2020 11:36, Praveen Kumar K S wrote:
>
> Hello All,
>
> I'm looking for hardware configurations to set up 1 master and 2
> hot-standby slaves using 9.6 in one DC. Also, I need to have DR with the
> same setup with cross-site replication enabled. I went through a lot of
> docs/blogs suggesting 4cores and at least 4/8GB RAM. But I'm looking for
> help on how exactly one can justify the hardware requirements, like a
> formula ? Please advise.
>
> Regards,
> PK
>
>
>

--

*Regards,*

*K S Praveen KumarM: +91-9986855625 *