Re: - Mailing list pgsql-performance

From Dan Harris
Subject Re:
Date
Msg-id 46410C6B.8030901@drivefaster.net
Whole thread Raw
In response to  ("Orhan Aglagul" <oaglagul@cittio.com>)
Responses Re:  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-performance
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.




pgsql-performance by date:

Previous
From: "Orhan Aglagul"
Date:
Subject:
Next
From: "Joshua D. Drake"
Date:
Subject: Re: