Postgresql high demand server

[IT]

Hi Doug and Stene,

Thank you for your valuable input.

regards

xavier


> El 10 ene 2024, a las 8:41, Sten-Erik Björling, <s-e.bjorling at enviro.se> escribió:
> 
> Hi all,
> 
> Good info from Doug, some additional info below…
> 
> Mac Studio Ultra has a memory access speed of 800 GB/sec which is very high and allow very fast performance once your settings allow you to manage close to all the data in memory due to effective caches. In tests that I have seen earlier, the achieved performance of PostgreSQL with Mac Studio Ultra, the performance where close the performance of 32/64 core AMD Rome class processors - the cost of that processor alone where close the cost of the Mac Studio Ultra itself at that time.
> 
> 
> 
> Another factor - Mac Studio Ultra mostly utilising its CPU cores have a fairly low energy consumption - mostly around 35 watts compared to a X86 system that consumes multiples of that - which is and will become even more important over time with raised energy costs - also for cooling…
> 
> Finally, there is a good tool for optimising the configuration file in PostgreSQL for different use scenarios: https://pgtune.leopard.in.ua/
> 
> Take care, all the best…
> 
> Stene
> 
> ______
> 
> Sent from my iPad
> 
>> 10 jan. 2024 kl. 01:27 skrev Doug Easterbrook via omnisdev-en <omnisdev-en at lists.omnis-dev.com>:
>> 
>> hi xavier.
>> 
>> 2020 was so long ago.
>> 
>> for really fast postgres to handle a lot of transactions, our cloud is now
>> linux (ubuntu)
>> we are using multiple nVME M.2 SSD drives with theoretical throughput of 20gigabit/sec transfer rate
>> lots of ram. (all our servers have 256 gigabit of ram)
>> many cores. currently that are like 40 cores AMD chips
>> 
>> with that, we support hundreds of databases for customers
>> 
>> 
>> 
>> if you just need one a single business that is off the shelf and pretty freaking fast, look to the Mac studio (https://www.apple.com/ca/mac-studio/)
>> 
>> 12 core starts at 1999 USD
>> 24 core starts at 3999 USD
>> 
>> they have read/write speeds of over 5gigabit/sec. (which is 1/4 speed of nVME M.2 drives)
>> 
>> 
>> 
>> not a lot of difference between linux and mac as far as installling after configuring postgres.   Mac has a double click installer, linux you have to use apt-get.   but once installed, configuration is the same (just different directories) and starting/stopping the database is the same
>> 
>> 
>> 
>> hope that helps .      Sorry my last note was so ’20’s.  grin.  4 years makes a difference.
>> 
>> 
>> 
>> 
>> 
>> Doug Easterbrook
>> Arts Management Systems Ltd.
>> mailto:doug at artsman.com
>> http://www.artsman.com
>> Phone (403) 650-1978
>> 
>>> On Jan 9, 2024, at 7:10 AM, IT <it at plastipol.com> wrote:
>>> 
>>> Ye, Kelly. That was.
>>> 
>>> Thank you!
>>> 
>>> xavier
>>> 
>>>>> El 9 ene 2024, a las 11:01, Kelly Burgess <kellyb at montana.com> escribió:
>>>> 
>>>>> I have been searching for the message in the list with no luck.
>>>> 
>>>> Was this the one?
>>>> 
>>>>   https://lists.omnis-dev.com/pipermail/omnisdev-en/2020-February/042524.html
>>>> 
>>>> Kelly
>>>> _____________________________________________________________
>>>> Manage your list subscriptions at https://lists.omnis-dev.com
>>>> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com
>>> 
>>> _____________________________________________________________
>>> Manage your list subscriptions at https://lists.omnis-dev.com
>>> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com
>> 
>> _____________________________________________________________
>> Manage your list subscriptions at https://lists.omnis-dev.com
>> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com
> _____________________________________________________________
> Manage your list subscriptions at https://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com