"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
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
