Re: Bytea poor performance

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" <nso@fmf.vtu.lt> 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.