pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedThe sizing of HW resources of a physical PG server
6+ messages / 4 participants
[nested] [flat]
* The sizing of HW resources of a physical PG server
@ 2016-09-13 11:25 Poul Kristensen <bcc5226@gmail.com>
0 siblings, 3 replies; 6+ messages in thread
From: Poul Kristensen @ 2016-09-13 11:25 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: The sizing of HW resources of a physical PG server
@ 2016-09-13 11:36 hubert depesz lubaczewski <depesz@depesz.com>
parent: Poul Kristensen <bcc5226@gmail.com>
2 siblings, 0 replies; 6+ messages in thread
From: hubert depesz lubaczewski @ 2016-09-13 11:36 UTC (permalink / raw)
To: Poul Kristensen <bcc5226@gmail.com>; +Cc: pgsql-admin
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/
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: The sizing of HW resources of a physical PG server
@ 2016-09-13 12:03 Imre Samu <pella.samu@gmail.com>
parent: Poul Kristensen <bcc5226@gmail.com>
2 siblings, 1 reply; 6+ messages in thread
From: Imre Samu @ 2016-09-13 12:03 UTC (permalink / raw)
To: Poul Kristensen <bcc5226@gmail.com>; +Cc: pgsql-admin
>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@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
>
>
>
>
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: The sizing of HW resources of a physical PG server
@ 2016-09-13 12:18 Eduardo Morras <emorrasg@yahoo.es>
parent: Poul Kristensen <bcc5226@gmail.com>
2 siblings, 0 replies; 6+ messages in thread
From: Eduardo Morras @ 2016-09-13 12:18 UTC (permalink / raw)
To: pgsql-admin
On Tue, 13 Sep 2016 13:25:21 +0200
Poul Kristensen <bcc5226@gmail.com> 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 <emorrasg@yahoo.es>
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: The sizing of HW resources of a physical PG server
@ 2016-09-13 13:18 Poul Kristensen <bcc5226@gmail.com>
parent: Imre Samu <pella.samu@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Poul Kristensen @ 2016-09-13 13:18 UTC (permalink / raw)
To: pgsql-admin
Thanks a lot Imre !
Very usefull !
br,
Poul
2016-09-13 14:03 GMT+02:00 Imre Samu <pella.samu@gmail.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@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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: The sizing of HW resources of a physical PG server
@ 2016-09-13 16:05 Imre Samu <pella.samu@gmail.com>
parent: Poul Kristensen <bcc5226@gmail.com>
0 siblings, 0 replies; 6+ messages in thread
From: Imre Samu @ 2016-09-13 16:05 UTC (permalink / raw)
To: Poul Kristensen <bcc5226@gmail.com>; +Cc: 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@gmail.com>:
> Thanks a lot Imre !
> Very usefull !
>
> br,
> Poul
>
>
>
>
> 2016-09-13 14:03 GMT+02:00 Imre Samu <pella.samu@gmail.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@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
>
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2016-09-13 16:05 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2016-09-13 11:25 The sizing of HW resources of a physical PG server Poul Kristensen <bcc5226@gmail.com>
2016-09-13 11:36 ` hubert depesz lubaczewski <depesz@depesz.com>
2016-09-13 12:03 ` Imre Samu <pella.samu@gmail.com>
2016-09-13 13:18 ` Poul Kristensen <bcc5226@gmail.com>
2016-09-13 16:05 ` Imre Samu <pella.samu@gmail.com>
2016-09-13 12:18 ` Eduardo Morras <emorrasg@yahoo.es>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox