Re: Insert are going slower ...

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