PostgreSQL performance on ARM i.MX6

From: "Druckenmueller, Marc" <marc(dot)druckenmueller(at)philips(dot)com>
To: "pgsql-performance(at)lists(dot)postgresql(dot)org" <pgsql-performance(at)lists(dot)postgresql(dot)org>
Subject: PostgreSQL performance on ARM i.MX6
Date: 2023-05-23 11:42:53
Message-ID: VI1P122MB01741C0DBFCE0AC2F51DBB66FB409@VI1P122MB0174.EURP122.PROD.OUTLOOK.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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.

import psycopg as pg
conn = pg.connect('dbname=test')
conn.autocommit = True
cur = conn.cursor()
while True:
cur.execute("call dummy_call(%s,%s,%s, ARRAY[%s, %s, %s]::real[]);", (1,2,3, 4.0, 5.0, 6.0), binary=True )

where the called procedure is basically a no-op:

CREATE OR REPLACE PROCEDURE dummy_call(
in arg1 int,
in arg2 int,
in arg3 int,
in arg4 double precision[])
AS $$
BEGIN
END
$$ LANGUAGE plpgsql;

This seems to be a quite low number of requests/s, given that there are no changes to the database.
Looking for suggestions what could cause this poor performance and where to start investigations.

Thanks,

Marc

________________________________
The information contained in this message may be confidential and legally protected under applicable law. The message is intended solely for the addressee(s). If you are not the intended recipient, you are hereby notified that any use, forwarding, dissemination, or reproduction of this message is strictly prohibited and may be unlawful. If you are not the intended recipient, please contact the sender by return e-mail and destroy all copies of the original message.

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Daniele Varrazzo 2023-05-23 13:25:22 Re: PostgreSQL performance on ARM i.MX6
Previous Message aditya desai 2023-05-11 18:40:06 Connection drops on postgres 11.16