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

2014-02-19 Thread Merlin Moncure
On Tue, Feb 18, 2014 at 2:41 PM, 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

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

2014-02-19 Thread Scott Marlowe
On Wed, Feb 19, 2014 at 8:13 AM, Merlin Moncure wrote: > On Tue, Feb 18, 2014 at 2:41 PM, 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 ra

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

2014-02-19 Thread Tomas Vondra
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/write cache ratio in >>> writeback-ca

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

2014-02-19 Thread Merlin Moncure
On Wed, Feb 19, 2014 at 12:09 PM, Scott Marlowe wrote: > On Wed, Feb 19, 2014 at 8:13 AM, Merlin Moncure wrote: >> On Tue, Feb 18, 2014 at 2:41 PM, 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 l

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

2014-02-19 Thread Tomas Vondra
On 19.2.2014 16:13, Merlin Moncure wrote: > On Tue, Feb 18, 2014 at 2:41 PM, 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 >>> wri

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

2014-02-19 Thread Tomas Vondra
On 19.2.2014 19:09, Scott Marlowe wrote: > > You can also do the old trick of underprovisioning and / or > underutilizing all the space on SSDs. I.e. put 10 600GB SSDs under a > HW RAID controller in RAID-10, then only parititon out 1/2 the storage > you get from that. so you get 1.5TB os storage

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

2014-02-19 Thread Scott Marlowe
On Wed, Feb 19, 2014 at 6:10 PM, Tomas Vondra wrote: > On 19.2.2014 19:09, Scott Marlowe wrote: >> Right now I'm testing on a machine with 2x Intel E5-2690s >> (http://ark.intel.com/products/64596/intel-xeon-processor-e5-2690-20m-cache-2_90-ghz-8_00-gts-intel-qpi) >> 512GB RAM and 6x600GB Intel S

Re: [PERFORM] Problem with ExclusiveLock on inserts

2014-02-19 Thread Ilya Kosmodemiansky
Vladimir, pgbouncer works with pl/proxy in transaction pooling mode. A wide spread phrase that statement mode is for plproxy does not mean any limitations for transaction pooling mode until you have atocommit on client. Anyway, try to reduce connections. try to set your autovacuum a bit more aggr