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.
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster