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

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