Re:

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.