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
Last activity: Nov 17, 2023, 02:29 PM