Re: Bytea poor performance - Mailing list pgsql-performance

From Tom Lane
Subject Re: Bytea poor performance
Date
Msg-id 29778.1129391647@sss.pgh.pa.us
Whole thread Raw
In response to Bytea poor performance  ("NSO" <nso@fmf.vtu.lt>)
Responses Re: Bytea poor performance  ("NSO" <nso@fmf.vtu.lt>)
List pgsql-performance
"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

pgsql-performance by date:

Previous
From: "NSO"
Date:
Subject: Re: Bytea poor performance
Next
From: "NSO"
Date:
Subject: Re: Bytea poor performance