Re: The sizing of HW resources of a physical PG server

From: Poul Kristensen <bcc5226(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: The sizing of HW resources of a physical PG server
Date: 2016-09-13 13:18:01
Message-ID: CAAOuvVohuteP6B_GAjqoTp+C7ggP6PB+eyG8hb6JPQuBQxBhqg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Thanks a lot Imre !
Very usefull !

br,
Poul

2016-09-13 14:03 GMT+02:00 Imre Samu <pella(dot)samu(at)gmail(dot)com>:

> >How to size a physical PG server?
>
> Some things I hope you will find useful :
> https://momjian.us/main/writings/pgsql/hw_selection.pdf
> http://momjian.us/main/writings/pgsql/hw_performance/index.html
> https://wiki.postgresql.org/wiki/Database_Hardware
> http://www.slideshare.net/PostgreSQL-Consulting/linux-
> tuning-to-improve-postgresql-performance
>
>
> Best,
> Imre
>
> 2016-09-13 13:25 GMT+02:00 Poul Kristensen <bcc5226(at)gmail(dot)com>:
>
>>
>> Hi !
>>
>> How to size a physical PG server?
>>
>> What does a physical PG server like concerning HW resources?
>> number of cpu's(cache L1 expensive I think, L2 and L3), RAM?
>>
>> Thanks
>>
>> Poul
>>
>>
>>
>>
>>
>
>

--
Med venlig hilsen / Best regards
Poul Kristensen
Linux-OS/Virtualizationexpert and Oracle DBA

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Kevin Grittner 2016-09-13 15:32:06 Re: Autovacuum Running Timeframe
Previous Message Eduardo Morras 2016-09-13 12:18:54 Re: The sizing of HW resources of a physical PG server