Sample Header Ad - 728x90

Does it make sense to enlarge "shared_buffers" for writing Postgresql?

0 votes
1 answer
702 views
I'm using Postgresql-11, with a traditional HDD as the physical storing device. I need to optimize the performance for writing. I have changed the wal_buffers from -1 to 512MB, that means that wal_buffers no long use shared_buffers. Am I right? I want to know whether or not it can improve the writing performance to enlarge shared_buffers. In my mind, it is used only for querying? The current value of shared_buffers is 2GB, my RAM is 8GB. I want to change it to 4GB. thanks!
Asked by Leon (411 rep)
Feb 3, 2023, 03:51 AM
Last activity: Feb 3, 2023, 11:49 PM