Re: PostgreSQL performance on ARM i.MX6

2023-05-23 Thread Ranier Vilela
Em ter., 23 de mai. de 2023 às 08:43, Druckenmueller, Marc < marc.druckenmuel...@philips.com> escreveu: > 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),

Re: PostgreSQL performance on ARM i.MX6

2023-05-23 Thread Richard Huxton
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

Re: PostgreSQL performance on ARM i.MX6

2023-05-23 Thread Tom Lane
"Druckenmueller, Marc" writes: > 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. That does seem pretty awful for modern hardware, but it's hard to

Re: PostgreSQL performance on ARM i.MX6

2023-05-23 Thread Daniele Varrazzo
On Tue, 23 May 2023 at 13:43, Druckenmueller, Marc wrote: > Testing with a simple python script (running on the same CPU), I get ~1000 > request/s. Is the time spent in the client or in the server? Are there noticeable differences if you execute that statement in a loop in psql (with the

PostgreSQL performance on ARM i.MX6

2023-05-23 Thread Druckenmueller, Marc
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 =