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.