Re: Increased iowait and blk_read_time with higher shared_buffers

2022-12-14 Thread Jordan Hurwich
ed for > PostgreSQL and there is no other service running on them. > > Best regards. > Samed YILDIRIM > > > On Wed, 14 Dec 2022 at 20:12, Jordan Hurwich > wrote: > >> Thanks for your thoughtful response Samed. >> >> I'm familiar with the article you link

Re: Increased iowait and blk_read_time with higher shared_buffers

2022-12-14 Thread Jordan Hurwich
Thanks Tom, that makes a lot of sense. Given we're seeing low iowait and blk_read_time at 4GB shared_buffers, sounds like we should just declare victory here and be happy with that setting? On Wed, Dec 14, 2022 at 10:27 AM Tom Lane wrote: > Jordan Hurwich writes: > > I'

Re: Increased iowait and blk_read_time with higher shared_buffers

2022-12-14 Thread Jordan Hurwich
erformance. > > To conclude, your results are expected results. > > A useful resource to read: > https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server > >> . given the way PostgreSQL also relies on the operating system >> cache, it's unlikely you&#x