An interesting example of performance using SQL workers and different tricks...

[Marc De Roover]

Doug,

We deployed 15.1 and “feel” its faster, no benchmarking done.

Marc


On 28 Nov 2022, at 18:07, Doug Easterbrook via omnisdev-en wrote:

> hi Sten
>
> Are you comparing this to earlier postgres performance, or just 
> pleasantly surprised at what the M1 mac’s can do vis-a-vis 
> performance.
>
> I have 14.6 on my machine - I haven’t taken the jump to the next 
> version — so I wanted to know if I should be looking for something 
> noticeable (I hope so)
>
> Doug Easterbrook
> Arts Management Systems Ltd.
> mailto:doug at artsman.com
> http://www.artsman.com
> Phone (403) 650-1978
>
>> On Nov 28, 2022, at 7:38 AM, Sten-Erik Björling 
>> <s-e.bjorling at enviro.se> wrote:
>>
>> Hi all,
>>
>> Done some testing after some optimisation using the DVD Rental 
>> example database running on PostgreSQL 15 on a MacBook Pro Max with a 
>> 5-client web server….
>>
>> Calls per second: 350
>> Processing load on one processor: 46%
>> The number of active connections to PostgreSQL: 5 (equal load 
>> distribution).
>>
>> Of course, there will be latencies etc. involved in a real 
>> implementation but this performance is impressive. A 10-user license 
>> might achieve close to 650 calls per second with a full load on one 
>> processor core.
>>
>> Good to know - especially since an optimal server structure for a 
>> small implementation is an Apple Studio Max - drawing around 30 Wats 
>> for all CPU cores. For one core maybe a total of 15 watts…
>>
>> Take care, all the best…
>>
>> Stene
>>
>> ______
>>
>>
>> Sten-Erik Björling
>> Enviro Data
>> Kyrkogatan 5A 2 tr
>> SE-972 32  Luleå
>> Sweden
>>
>> E-Mail: s-e.bjorling at enviro.se
>> Mobile: +46-70-655 11 72
>> Wire: @stenerikbjorling
>> Skype: stenerikbjorling
>> iChat: stene at icloud.com
>> Signal: +46 70 655 11 72
>> FaceTime: stene at icloud.com
>> Telegram: @stenerikbjorling
>> Hotmail / Messenger: stenerikbjorling at hotmail.com
>> GMail: stenerikbjorling at gmail.com
>> ______
>>
>> This email and any files transmitted with it are confidential, may be 
>> legally privileged and are intended solely for the use of the 
>> individual or entity to whom they are addressed. If you are not the 
>> intended recipient, please note that any use, distribution, or 
>> reproduction of the contents of this email is strictly prohibited and 
>> may be unlawful. If you are not the intended recipient, please notify 
>> the sender by return email and destroy all copies of the original 
>> message including any attachments thereto. Thank you.
>>
>> Please note that we take reasonable precautions to prevent the 
>> transmission of viruses; however, we cannot guarantee that this email 
>> or its attachments are free from viruses. We only send and receive 
>> emails on the basis that we are not be liable for any loss or damage 
>> resulting from the opening of this message and/or attachments.
>>
>> _____________________________________________________________
>> 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
ARC - your Apple service partner