Re: PostgreSQL performance on ARM i.MX6

On 2023-05-23 12:42, Druckenmueller, Marc wrote:
> Hi there,
> 
> I am investigating possible throughput with PostgreSQL 14.4 on an ARM
> i.MX6 Quad CPU (NXP sabre board).
> 
> Testing with a simple python script (running on the same CPU), I get
> ~1000 request/s.

I tweaked your script slightly, but this is what I got on the Raspberry 
Pi 4 that I have in the corner of the room. Almost twice the speed you 
are seeing.

     0: this = 0.58 tot = 0.58
     1: this = 0.55 tot = 1.13
     2: this = 0.59 tot = 1.72
     3: this = 0.55 tot = 2.27
     4: this = 0.56 tot = 2.83
     5: this = 0.57 tot = 3.40
     6: this = 0.56 tot = 3.96
     7: this = 0.55 tot = 4.51
     8: this = 0.59 tot = 5.11
     9: this = 0.60 tot = 5.71

That's with governor=performance and a couple of background tasks 
running as well as the python. PostgreSQL 15 in a container on a Debian 
O.S. I've not done any tuning on PostgreSQL (but your call isn't doing 
anything really) nor the Pi.

The minor tweaks to your script were as below:

     import psycopg as pg
     import time

     conn = pg.connect('')
     conn.autocommit = True
     cur = conn.cursor()
     start = time.time()
     prev = start
     end = start
     for j in range(10):
         for i in range(1000):
             cur.execute("call dummy_call(%s,%s,%s, ARRAY[%s, %s, 
%s]::real[]);", (1,2,3, 4.0, 5.0, 6.0), binary=True )
         end = time.time()
         print(f"{j}: this = {(end - prev):.2f} tot = {(end - 
start):.2f}")
         prev = end

-- 
   Richard Huxton