RE: CPU usage for queries, psycopg 2 vs 3

Поиск
Список
Период
Сортировка
От David Raymond
Тема RE: CPU usage for queries, psycopg 2 vs 3
Дата
Msg-id DB7PR07MB391650DB3D30B796DE2F81F687F9A@DB7PR07MB3916.eurprd07.prod.outlook.com
обсуждение исходный текст
Ответ на Re: CPU usage for queries, psycopg 2 vs 3  (Daniele Varrazzo <daniele.varrazzo@gmail.com>)
Ответы Re: CPU usage for queries, psycopg 2 vs 3
Список psycopg
Looks good. With the change it quietly idles while waiting for query results, with no CPU spike.

-David

> Hello David,
>
> On Thu, 7 Sept 2023 at 14:17, David Raymond <David.Raymond@tomtom.com> wrote:
>>
>> > 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.

> I am not able to quickly investigate this issue, because I don't have
> a Windows machine handy. However I would like to release 3.1.11 soon,
> so I would like to merge this changeset, which should revert the wait
> function to what was in 3.1.4 on Windows:

> Are you able to test it to verify that CPU usage is regular with this changeset?


> Cheers

> -- Daniele



В списке psycopg по дате отправления:

Предыдущее
От: Daniele Varrazzo
Дата:
Сообщение: Re: CPU usage for queries, psycopg 2 vs 3
Следующее
От: Daniele Varrazzo
Дата:
Сообщение: Re: CPU usage for queries, psycopg 2 vs 3