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