Hello,
Yes, I can understand that, but then why the same app on the server
machine is done in 4 seconds? (big difference from 20-30 seconds). I
tryed to monitor network traffic and it is used only for 1-2% of total
100mbit.
> "NSO" <[EMAIL PROTECTED]> writes:
>> Query runs very long:
>> Total query runtime: 23625 ms.
>> Data retrieval runtime: 266 ms.
>> 50 rows retrieved.
>
> Notice that the query itself took 266ms. The rest of the time was
> wasted by your client app trying to format a 23Kb by 50 row table
> for display. You need to replace your client-side code with something
> less inefficient about handling wide values.
>
> regards, tom lane
>
> --
> This message has been scanned for viruses and
> dangerous content, and is believed to be clean.
>
>
--
This message has been scanned for viruses and
dangerous content, and is believed to be clean.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
