> >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 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq