Shridhar, > I suggest you check this first. Check the performance tuning guide.. > > http://www.varlena.com/varlena/GeneralBits/Tidbits/index.php > > That is a starters. As Josh suggested, increase checkpoint segments if you have > disk space. Correspondingly WAL disk space requirements go up as well.
Well, not if he has fsync=off. But having fsync off is a very bad idea. You do realize, Herve', that if you lose power on that machine you'll most likely have to restore from backup? -- -Josh Berkus Aglio Database Solutions San Francisco ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster