From: | Imre Samu <pella(dot)samu(at)gmail(dot)com> |
---|---|
To: | Poul Kristensen <bcc5226(at)gmail(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: The sizing of HW resources of a physical PG server |
Date: | 2016-09-13 16:05:38 |
Message-ID: | CAJnEWwk1+=wcft=Lym76GMJpiJLOCM2ppjVq_8-2ryAx39J-hQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
one more :
The video version of Bruce Momjian "Database Hardware Selection
Guidelines" [1] can be see on the youtube:
"Database Hardware Selection Guidelines - Bruce Momjian" ( Postgres Open
<https://www.youtube.com/channel/UCCDA5Yte0itW_Bf6UHpbHug> 2015)
https://www.youtube.com/watch?v=qIlYZeSuv8w ( 50min )
other : https://www.youtube.com/results?search_query=BRUCE+MOMJIAN+hardware
[1] https://momjian.us/main/writings/pgsql/hw_selection.pdf
2016-09-13 15:18 GMT+02:00 Poul Kristensen <bcc5226(at)gmail(dot)com>:
> 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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Alex Sviridov | 2016-09-15 15:30:57 | pgAdmin3 backup over ssh tunnel |
Previous Message | Kevin Grittner | 2016-09-13 15:32:06 | Re: Autovacuum Running Timeframe |