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

[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