Sample Header Ad - 728x90

Slow performance on representing select bytea column query of table in PostgreSQL

0 votes
1 answer
1376 views
Is it possible to improve representing data to client when they send command select bytea from table limit 150;. It consumes one minute and half but in pg_activity I see "client_write" waiting event. we use 10gbit network. DB version is PostgreSQL 13. When I create a table from that result, it has 285 MB table size. Oddly, select count(*) from (select bytea from table) only takes 10 ms. Is there any tip or a way to improve representing performance?
Asked by Melih (284 rep)
Nov 17, 2023, 08:54 AM
Last activity: Nov 17, 2023, 02:29 PM