The sizing of HW resources of a physical PG server

Поиск
Список
Период
Сортировка
Искать

The sizing of HW resources of a physical PG server

От:
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 

 

  

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

От:
hubert depesz lubaczewski <depesz@depesz.com>
Дата:
On Tue, Sep 13, 2016 at 01:25:21PM +0200, Poul Kristensen wrote:
> 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?

you have to know/understand how large your database, and its active set
will be, and how many queries you need to run concurrently/per-second.

once you have this information - you can establish some minimums.

Best regards,

depesz

-- 
The best thing about modern society is how easy it is to avoid contact with it.
                                                             http://depesz.com/

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

От:
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 

 

  

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

От:
Eduardo Morras <emorrasg@yahoo.es>
Дата:
On Tue, 13 Sep 2016 13:25:21 +0200
Poul Kristensen  wrote:

> 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?

a) Amount of data
b) Type of data (text (books), numeric (business data), real (scientific data), ...)
c) Relationship between data
d) Type of queries (OLTP/OLAP//Graph/... or Read vs Write or...)

Too much to answer in a mail. Check docs and manual

> Thanks
> 
> Poul


---   ---
Eduardo Morras 

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

От:
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

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

От:
Imre Samu <pella.samu@gmail.com>
Дата:
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

FAQ