Re: [PERFORM] Configuration Recommendations

2012-05-02 Thread Jan Nielsen
Below is the hardware, firmware, OS, and PG configuration pieces that I'm settling in on. As was noted, the local storage used for OS is actually two disks with RAID 10. If anything appears like a mistake or something is missing, I'd appreciate the feedback. I'm still working on the benchmarks scr

Re: [PERFORM] Several optimization options (config/hardware)

2012-05-02 Thread Tomas Vondra
Hi, On 2 Květen 2012, 15:19, Martin Grotzke wrote: > Hi, > > we want to see if we can gain better performance with our postgresql > database. In the last year the amount of data growed from ~25G to now > ~140G and we're currently developing a new feature that needs to get > data faster from the da

[PERFORM] Several optimization options (config/hardware)

2012-05-02 Thread Martin Grotzke
Hi, we want to see if we can gain better performance with our postgresql database. In the last year the amount of data growed from ~25G to now ~140G and we're currently developing a new feature that needs to get data faster from the database. The system is both read and write heavy. At first I wa