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

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
>

In response to

Browse pgsql-admin by date

  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