Re: [PERFORM] PG performance issues related to storage I/O waits

2013-07-31 Thread KONDO Mitsumasa
Hi Tasos, (2013/07/31 20:58), Tasos Petalas wrote: We have set synchronous_commit to off but since almost all of application queries are using prepared statements we don't get any real benefit. Also please advise on any postgres.conf modification that could significantly affect storage load

Re: [PERFORM] Optimal settings for RAID controller - optimized for writes

2014-02-17 Thread KONDO Mitsumasa
Hi, I don't have PERC H710 raid controller, but I think he would like to know raid striping/chunk size or read/write cache ratio in writeback-cache setting is the best. I'd like to know it, too:) Regards, -- Mitsumasa KONDO NTT Open Source Software Center (2014/02/18 0:54), Tomas Vondra wrot

Re: [PERFORM] Optimal settings for RAID controller - optimized for writes

2014-02-18 Thread KONDO Mitsumasa
(2014/02/19 5:41), Tomas Vondra wrote: On 18.2.2014 02:23, KONDO Mitsumasa wrote: Hi, I don't have PERC H710 raid controller, but I think he would like to know raid striping/chunk size or read/write cache ratio in writeback-cache setting is the best. I'd like to know it, too:)

Re: [PERFORM] Optimal settings for RAID controller - optimized for writes

2014-02-20 Thread KONDO Mitsumasa
Hi, (2014/02/20 9:13), Tomas Vondra wrote: Hi, On 19.2.2014 03:45, KONDO Mitsumasa wrote: (2014/02/19 5:41), Tomas Vondra wrote: On 18.2.2014 02:23, KONDO Mitsumasa wrote: Hi, I don't have PERC H710 raid controller, but I think he would like to know raid striping/chunk size or read/