To put it simple, you need to set checkpoint_segments way higher than your current value!
Link: wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server On Aug 4, 2011 6:57 AM, "Adarsh Sharma" <adarsh.sha...@orkash.com> wrote:
- [PERFORM] Need to tune for Heavy Write Adarsh Sharma
- Re: [PERFORM] Need to tune for Heav... Dusan Misic
- Re: [PERFORM] Need to tune for Heav... Willy-Bas Loos
- Re: [PERFORM] Need to tune for ... Scott Marlowe
- Re: [PERFORM] Need to tune ... Dusan Misic
- Re: [PERFORM] Need to tune ... Nicholson, Brad (Toronto, ON, CA)
- Re: [PERFORM] Need to t... Scott Marlowe
- Re: [PERFORM] Need to tune for Heav... Dusan Misic
- Re: [PERFORM] Need to tune for Heav... Craig Ringer
- Re: [PERFORM] Need to tune for Heav... Kevin Grittner
- Re: [PERFORM] Need to tune for ... Scott Marlowe
- Re: [PERFORM] Need to tune ... Jim Nasby
- Re: [PERFORM] Need to tune for Heav... Samuel Gendler
- Re: [PERFORM] Need to tune for ... Mark Kirkwood
