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