| From: | Prince Pathria <prince(dot)pathria(at)goevive(dot)com> |
|---|---|
| To: | suganthi Sekar <suganthi(at)uniphore(dot)com> |
| Cc: | "pgsql-performance(at)lists(dot)postgresql(dot)org" <pgsql-performance(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Fw: server hardware tuning. |
| Date: | 2019-02-04 14:45:30 |
| Message-ID: | CAON0Day=M6164EehJo1M-CS95c22fpGrArm_pVwJ9tjzaRYujg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Hi Suganthi,
I can give you a start, some pro users can suggest you better.
1. Don't use this much of connections on a single postgres server. Use a
connection pooler in front of it.
2. RAM: Depends upon how much data you want to be cached.
3. Use PCIe SATA SSD with RAID10, Postgres uses a lot of IO for its
operations.
4. For config tuning: https://pgtune.leopard.in.ua/#/ Though please go
through all params for more understanding
Happy to help :)
Prince Pathria Systems Architect Intern Evive +91 9478670472 goevive.com
On Mon, Feb 4, 2019 at 6:07 PM suganthi Sekar <suganthi(at)uniphore(dot)com> wrote:
>
> Hi ,
>
>
> I need know how to calculate hardware sizing for database or query
>
>
> RAM
>
> CPU
>
> Config tuning
>
>
> Requirement :
>
>
> 1100 concurrent connection
>
> 1600 column of table
>
> 1GB of data can be select and dynamic aggregation will happen
>
>
> Regards
>
> SuganthiSekar
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andreas Joseph Krogh | 2019-02-04 14:56:45 | Sv: Re: Fw: server hardware tuning. |
| Previous Message | suganthi Sekar | 2019-02-04 09:57:31 | Fw: server hardware tuning. |