| From: | David Raymond <David(dot)Raymond(at)tomtom(dot)com> |
|---|---|
| To: | Daniele Varrazzo <daniele(dot)varrazzo(at)gmail(dot)com> |
| Cc: | "psycopg(at)postgresql(dot)org" <psycopg(at)postgresql(dot)org> |
| Subject: | RE: CPU usage for queries, psycopg 2 vs 3 |
| Date: | 2023-09-07 12:17:40 |
| Message-ID: | DB7PR07MB39169ECBC7E0E02E8315982F87EEA@DB7PR07MB3916.eurprd07.prod.outlook.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | psycopg |
> Could you please be so kind as to repeat your tests with psycopg 3.1.4?
Tried with 3.1.4 and it has idle processor usage while waiting for the 8 results, just like psycopg2.
Tried with 3.1.5 and it spikes up to 62% reported CPU usage while waiting for the 8 results, just like the current release.
> Also, did you try only to connect on localhost? Are you able to run the same test with a server running on a different network location?
Have now tried with both a local host, and spreading the connections out over a number of remote servers, and the results are the same for both situations.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Daniele Varrazzo | 2023-09-07 12:43:58 | Re: CPU usage for queries, psycopg 2 vs 3 |
| Previous Message | Daniele Varrazzo | 2023-09-06 23:05:43 | Re: CPU usage for queries, psycopg 2 vs 3 |