You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
Repository navigation
Major performance issues with bytea performance #2240
I encountered the exact same issue as #1286 wheres a simple query to retrieve a 100mb bytea column from a one table, one row DB takes forever and causes the cpu to spike at 100%, rendering my node instance unresponsive.
After investigating, I think I found the cause in the pg-protocol package
Which suffers from the same thing as the original issue - too many allocations and buffer copies going around. I believe the fix introduced back then in brianc/node-packet-reader#3 should solve the problem here.
Activity
fix: major performance issues with bytea performance brianc#2240
fix: major performance issues with bytea performance brianc#2240
fix: major performance issues with bytea performance brianc#2240
fix: major performance issues with bytea performance brianc#2240
fix: major performance issues with bytea performance brianc#2240
fix: major performance issues with bytea performance brianc#2240
fix: major performance issues with bytea performance brianc#2240
fix: major performance issues with bytea performance brianc#2240
fix: major performance issues with bytea performance brianc#2240
fix: major performance issues with bytea performance brianc#2240
fix: major performance issues with bytea performance brianc#2240
Merge pull request #2241 from PruvoNet/#2240
lognaturel commentedon Dec 12, 2020
Just started running into this and feeling very grateful to see it’s been fixed for a while now already! Thank you, @regevbr, @brianc. 😊
pg-protocol: defer DataRow cell decoding to a lazy `fields` getter