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

[Imre Samu <pella.samu@xxxxxxxxx>]

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 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@xxxxxxxxx>:

Thanks a lot Imre !

Very usefull !

br,

Poul

2016-09-13 14:03 GMT+02:00 Imre Samu <pella.samu@xxxxxxxxx>:

>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@xxxxxxxxx>:

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