News for hackers. Stuff that matters.
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.
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?
Re:Debugging random slow writes in PostgreSQL by fuy on Wednesday May 19, 2021 @02:58AM (#27205461)