Postgres Pro
Downloads
Home   >   mailing lists

Re: The sizing of HW resources of a physical PG server - Mailing list pgsql-admin

From Imre Samu
Subject Re: The sizing of HW resources of a physical PG server
Date
Msg-id CAJnEWwk1+=wcft=Lym76GMJpiJLOCM2ppjVq_8-2ryAx39J-hQ@mail.gmail.com
Whole thread Raw
In response to Re: The sizing of HW resources of a physical PG server  (Poul Kristensen <bcc5226@gmail.com>)
List pgsql-admin
Tree view
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@gmail.com>:
Thanks a lot Imre !
Very usefull !

br,
Poul




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

2016-09-13 13:25 GMT+02:00 Poul Kristensen <bcc5226@gmail.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

pgsql-admin by date:

Previous
From: Kevin Grittner
Date:
Subject: Re: Autovacuum Running Timeframe
Next
From: Alex Sviridov
Date:
Subject: pgAdmin3 backup over ssh tunnel