Re: Very slow bytea extraction

Поиск
Список
Период
Сортировка
От msmbarabino@virgilio.it
Тема Re: Very slow bytea extraction
Дата
Msg-id 11192989288.msmbarabino@virgilio.it
обсуждение исходный текст
Ответ на Very slow bytea extraction  ("msmbarabino@virgilio.it" <msmbarabino@virgilio.it>)
Список pgsql-bugs
>
>No,
>actually I haven't yet.
>I have noticed that during the time
the query
>executes there is neither so much CPU load nor network
(communication
>with db) load. The client seems to hang, then after a
minute or so the
>query returns data.
>I also thought this problem
could be related to db
>encoding but changing it didn't help at all.
>If it's a client-related
>problem, I can't understand why such
different clients behave the same
>way


Checking Windows Task
Manager, after the query has been submitted, none of the postgresql
processes or client processes seems to be using CPU. The only process
that uses CPU is the System Idle Process (98 % CPU usage).
Both client
and server seem to be doing nothing.

Regards

Massimo

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

Предыдущее
От: "Zubkovsky, Sergey"
Дата:
Сообщение: "Permission denied" failures occurring on Windows
Следующее
От: "Guillaume Smet"
Дата:
Сообщение: Partial index on varchar fields with IN