Re: PostgreSQL performance on ARM i.MX6

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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





[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux