> 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

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?


Reply via email to