The often repeated recommendation to not exceed 8GB/25% of RAM for shared buffers in postgres is wrong. For pgbench scale 1500, on laptop with fast SSD and 32GB of RAM, parallelism of 16. s_b of 1GB, 8GB, 16GB, using huge pages. r/o: 115k, 100k, 185k r/w: 16300, 15100, 21500
-
-
Which means all the writes happen in a sorted manner (albeit with some gaps depending on write patterns). These days we, by default, prevent writeback storms caused by checkpointing, by issuing sync_file_range(SYNC_FILE_RANGE_WRITE) to control outstanding writes.
-
I was curious if the work by
@axboe helped Postgreshttps://lwn.net/Articles/682582/ … - 3 more replies
New conversation -
-
-
I was recently informed on Slack that it was changes around 9.6 (or possibly 10) that reduced the old wisdom to hearsay.
-
I think it was largely wrong before then too - there were a few more caveats though.
End of conversation
New conversation -
Loading seems to be taking a while.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.