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:) The stripe size

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

2014-02-18 Thread Tomas Vondra
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:) We do have dozens of H710 controllers, but not w

Re: [PERFORM] DB size and TABLE sizes don't seem to add up

2014-02-18 Thread David Wall
On 2/18/2014 12:34 AM, Heikki Linnakangas wrote: On 02/18/2014 12:14 AM, David Wall wrote: I am running PG 9.2.4 and I am trying to figure out why my database size shows one value, but the sum of my total relation sizes is so much less. Basically, I'm told my database is 188MB, but the sum of

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

2014-02-18 Thread Michael Stone
On Mon, Feb 17, 2014 at 04:29:10PM +0100, DFE wrote: 2xSSD (MLC) Raid1 for Operating System (CentOS 6.4) 4xSSD (SLC) Raid10 for WAL archive and a dedicated "fast tablespace", where we have most UPDATE actions (+ Hot spare). 10xHDD 15kRPM Raid5 for "default tablespace" (optimized for space, instea

Re: [PERFORM] DB size and TABLE sizes don't seem to add up

2014-02-18 Thread Heikki Linnakangas
On 02/18/2014 12:14 AM, David Wall wrote: I am running PG 9.2.4 and I am trying to figure out why my database size shows one value, but the sum of my total relation sizes is so much less. Basically, I'm told my database is 188MB, but the sum of my total relation sizes adds up to just 8.7MB, whic