CPU usage for queries, psycopg 2 vs 3

2023-09-05 Thread David Raymond
I've noticed that CPU usage for queries seems to have drastically increased going from psycopg2 to psycopg3. In psycopg2 a connection would sit quietly while waiting for the results, using next to no CPU. In psycopg it looks like the threads are using their core at full power, continuously chec

Re: CPU usage for queries, psycopg 2 vs 3

2023-09-05 Thread Adrian Klaver
On 9/5/23 10:51 AM, David Raymond wrote: I've noticed that CPU usage for queries seems to have drastically increased going from psycopg2 to psycopg3. In psycopg2 a connection would sit quietly while waiting for the results, using next to no CPU. In psycopg it looks like the threads are using