Today we are starting a series of deep talks about the database in general. In most scenarios, we go with a bottom-up approach unlike now we want some creativity we start from a top-down approach leaving your brain in a WOW mood for a while and configuring then I came with the cold water to flush your brain with "what makes a lot of sense" the Architecture of their database that support such a feature In was you want to start your own business now you got the things that blow everyone minds.
"jsonlog" logging format
Surprisingly, PostgreSQL 14 and previous versions didn't have a handle output format for the logs- was just plain text, leaving the developer to do some redundant work of converting the plain text to JSON format to be useful. I am not going to talk about the importance of having structured data- but what I can say is truly important.
Server statistics in shared memory
Back to school where you studied the OS class and how you were amazed by connecting two programs doing some functionality over the same memory. it is the case here, in earlier versions there was a separate process called the statistics collector, which would periodically query the server for performance data and store it in a separate file on disk. This approach could result in increased disk I/O and network traffic, as well as increased CPU usage by the statistics collector process itself. the new approach directly leaves the user with great control and flexibility over the memory with fast and efficient customized statistics to be later monitored or analyzed. although we introduced the "jsonlog" format but still the output of the shared memory is plain text.
You can ask PostgreSQL directly through their website about that, as I can't feel the worth of not changing the output format- maybe they have already posted an issue doing so LOL.
we are not done yet next time we will have a talk about more top features and by the end, we will start the series of discovering the Architecture that supports such Top features.
Reference
1- My brain
2- PostgreSQL Doc
Thanks for reading :>)
Top comments (0)