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

Reply via email to