Re:

[Dan Harris <fbsd@xxxxxxxxxxxxxxx>]

Orhan Aglagul wrote:
> Hi Everybody,
>
> I was trying to see how many inserts per seconds my application could 
> handle on various machines.
>
>
> I read that postgres does have issues with MP Xeon (costly context 
> switching). But I still think that with fsync=on 65 seconds is ridiculous.

CPU is unlikely your bottleneck..  You failed to mention anything about your I/O 
setup.  More details in this regard will net you better responses.  However, an 
archive search for insert performance will probably be worthwhile, since this 
type of question is repeated about once a month.