[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

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

2012-05-03 Thread Martin Grotzke
Hi Laurenz, On 05/03/2012 09:26 AM, Albe Laurenz wrote: > Martin Grotzke wrote: >> 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

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

2012-05-07 Thread Martin Grotzke
On 05/04/2012 09:57 AM, Albe Laurenz wrote: > Martin Grotzke wrote: >>> You could try different kernel I/O elevators and see if that >>> improves something. >>> >>> I have made good experiences with elevator=deadline and >>> elevator=noop. > >