Re:Debugging random slow writes in PostgreSQL
by mettamage on Saturday May 15, 2021 @04:45AM
(#27163526)
After reading a couple of chapters in Brendan Gregg’s book I tend to agree.
[ Parent
| on HN ]
Re:Debugging random slow writes in PostgreSQL
by bonobocop on Saturday May 15, 2021 @06:36AM
(#27164037)
I used BPF (using _both_ of Brendan Gregg's recent books!) on our Jenkins builds recently to figure out why `TRUNCATE` statements were taking longer than I expected.
The underlying cause was that `ext4` filesystem was journalled and the `fsync`s were waiting on `jbd2_log_wait_commit`, which offcpu sampling let me pick up.
I don't think I would have been able to trace the kernel call and link it all the way back to the application call without BPF (at least I wouldn't have been able to).
Re:Debugging random slow writes in PostgreSQL
by mettamage on Saturday May 15, 2021 @07:52AM
(#27164399)
Thanks for this story! I haven’t seen many practical examples yet.
Fun fun :)
Re:Debugging random slow writes in PostgreSQL
by avinassh on Sunday May 16, 2021 @03:38AM
(#27171940)
which book?