Obviously it'd be better to do merging before submitting IO to the kernel (which in this snapshot reduces 300k 8k iops, to 20k larger ones). But hey, details.pic.twitter.com/caab6Usxhz
You can add location information to your Tweets, such as your city or precise location, from the web and via third-party applications. You always have the option to delete your Tweet location history. Learn more
Obviously it'd be better to do merging before submitting IO to the kernel (which in this snapshot reduces 300k 8k iops, to 20k larger ones). But hey, details.pic.twitter.com/caab6Usxhz
That's with postgres doing unbuffered / direct IO using io_uring. 2.6GB/s is about the drives limit. Checkpointer using about 70% CPU at that point. ~60% of that inside the kernel. A good bit due to the unnecessarily small writes.
And it should be doable to optimize the PG side a good bit further. Well, time to make appending workloads not suck quite so badly (250MB/s on the same storage).pic.twitter.com/ejoWQxzOqR
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.